IF statement help

R

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
 
B

Beege

RudeYute said:
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
Click to expand...


So close...

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

Beege
 
B

Bob Phillips

=MAX(E22*0.5,0)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top