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

"KB" wrote in message
...
This is the formula that worked:
=IF(D54<=0,0,D54*0.8)

Thanks!

"KennyD" wrote:

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).

--
Nothing in life is ever easy - just get used to that fact.


"KB" wrote:

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!