Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement help
=IF((C29-C26)=0,C29-C26,0)
This a IF statement that returns a decrease in an amount with a positive number I used: =IF((C29-C26)<=0,C29-C26,0) for the increase in amount, however if there is an increase - it returns a negative amount. For example -10 000. I want this increase to be stated as a negative amount. How can I fix this? thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |