| 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! |
| 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) | |||
Threaded Mode
