calculate formula if cell value is positive, show 0 if negative

[KB]

Im' sure this is simple, but i am stuck.
I need a formula to show a % value of an adjacent cell IF that cells value
is POSITIVE, and if that same cells value is NEGATIVE, to show 0.
I use Standard Edition 2003 w/SP3. Any suggestions greatly appreciated.
Thank You!

 

[KennyD]

Hopefully quick and easy for you but here goes:
Say your reference value is in Cell A2. And you want to show your
percentage in Cell B2. In Cell B2 you could do something like
=If(A2>=0,A2,0).

 

[KB]

Kenny, had to play with it for a minute, but ended up with
this =IF(G54>0,G54*0.8)
This did what I needed to show in an adjacent cell 0 if negative#
or 80% of G54 if positive value inG54.
Thanks!

 

[KB]

This is the formula that worked:
=IF(D54<=0,0,D54*0.8)

Thanks!

 

[David Biddulph]

Another option is =MAX(D54*0.8,0)