| 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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement help
Maybe,
=IF(CC6<C29,C26-C29,C29-C26) Mike "help!" wrote: =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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement help
That does work but I still want to put a "0" in the cell if the increase is a
- amount.. This did work and put the increase as a positive amount. thank you "Mike H" wrote: Maybe, =IF(CC6<C29,C26-C29,C29-C26) Mike "help!" wrote: =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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement help
=MAX((C26-C29),(C29-C26),0)
might work. "help!" wrote in message ... That does work but I still want to put a "0" in the cell if the increase is a - amount.. This did work and put the increase as a positive amount. thank you "Mike H" wrote: Maybe, =IF(CC6<C29,C26-C29,C29-C26) Mike "help!" wrote: =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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement help
=IF((C29-C26)=0,C29-C26,0) could be =MAX(C29-C26,0)
=IF((C29-C26)<=0,C29-C26,0) could be =MIN(C29-C26,0) If you want to reverse the sign, then =-MIN(C29-C26,0) or =MAX(C26-C29,0) -- David Biddulph "help!" wrote in message ... =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! |
| Reply |
| 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 | |||
Linear Mode
