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

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!

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

Using the IF Function in Excel

You can use the IF function in Excel to achieve this. Here's the formula you can use:

In this formula, A1 is the cell you want to check if it's positive or negative. If A1 is greater than 0, the formula will multiply A1 by 0.1 (which is 10% in decimal form) and show the result. If A1 is less than or equal to 0, the formula will show 0.

1. You can adjust the formula to fit your specific needs.
2. For example, if you want to show a different percentage for positive values, you can change the 0.1 to a different decimal value.

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

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!

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

Kenny, had to play with it for a minute, but ended up with
this =IF(G540,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!

"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!

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

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!

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

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!