Help with formula

[edrachel]

I am trying to do a formula that will check two different cells and do
calculation and then return a number depending on the whether one cel
is more or less than 0. Example of formula:
=IF(E10>0,(D10+E10)*F10),IF(E10<0,(D10)*1)
I want the sheet to look at E10, if it is greater than 0,
then I want it to add D10+E10 together and then multiply the answer b
the factor located in cell F10 and return the answer,
or if cell E10 is less than 0, then I want it to return the answe
found in D10 or multiply D10 by 1. I do not want D10 multiplied by F1
if there is 0 in E10. I need one or the other returned depending on th
number found in E10.
How do I do this? I know it is simple and I must just having a senio
moment. Any help will be appreciated.

Thanks for your help

 

[Kevin H. Stecyk]

Hi,

=IF(E10>0,(D10+E10)*F10,IF(E10<0,D10,"E10 is 0"))

You have your greater than 0, less than 0, but you didn't specify what you
wanted when it is 0.

But this should help get you started.

Kevin

 

[Frank Kabel]

Hi
but you're nearly there?
=IF(E10>0,(D10+E10)*F10,IF(E10<0,D10,0))