IF statement help

[RudeYute]

Hi

What im trying to do is,
Calculate a Cell x say 0.5. If the result is a negative number, sho
0. If it is a positive number, work it out and show the answer. Jus
tried, and cant seem to get it right for some reason. I dont want t
have to use another cell for no reaon, as I need to present th
worksheet

This is what I tried, IF((E22*0.5)>0), (E22*0.5),

Thank

 

[Beege]

Hi,

What im trying to do is,
Calculate a Cell x say 0.5. If the result is a negative number, show
0. If it is a positive number, work it out and show the answer. Just
tried, and cant seem to get it right for some reason. I dont want to
have to use another cell for no reaon, as I need to present the
worksheet.

This is what I tried, IF((E22*0.5)>0), (E22*0.5), 0

Thanks

So close...

=IF(E22*.5>0,E22*.5,0)

Beege

 

[Bob Phillips]

=MAX(E22*0.5,0)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[RudeYute]

"RudeYute" <[email protected]> wrot
in
message news:[email protected]...
http://www.excelforum.com/showthread.php?threadid=527847


So close...

=IF(E22*.5>0,E22*.5,0)

Beege

Perfect, thanks