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

  • Thread starter Thread starter KB
  • Start date Start date
K

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!
 
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).
 
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!
 
Back
Top