Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
|
|||
|
|||
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: Code:
=IF(A10,A1*0.1,0)
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate the difference between negative and positive values | Excel Worksheet Functions | |||
column to show certain percent positive AND negative | Excel Discussion (Misc queries) | |||
Change cell value from positive to negative | Excel Discussion (Misc queries) | |||
Force function to show positive or negative number? | Excel Worksheet Functions | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) |