| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
negative value
I have created a soreadsheet with a field called 'Less 15% Reserve'.
want it to calculate the 15% amount based only if a positive numbe appears in the cell used for calculation, not if that amount is negative amount. How do I create the formula that would leave the cel at a '0' if in fact the calculator cell is a negative number? Please help! Thanks & Happy New Year Jo Attachment filename: summary log.xls Download attachment: http://www.excelforum.com/attachment.php?postid=39479 -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing color of negative bar when using Invert if negative | Charts and Charting in Excel | |||
| I want to get negative hours if subtraction of hours is negative | Excel Worksheet Functions | |||
| Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| 2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
Threaded Mode
