| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement
I am not sure what to do here.
I have a worksheet and if C29 - C26 =0, I want the cell to dispay the amount (for example 20000 - 15000= 50000) but if it is <=0, I want the cell to display 0. Can I use an IF statment for this? How would I do this? thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement
Hi,
You could use IF but don't need it, try this =MAX(0,C29-C26) Mike "help!" wrote: I am not sure what to do here. I have a worksheet and if C29 - C26 =0, I want the cell to dispay the amount (for example 20000 - 15000= 50000) but if it is <=0, I want the cell to display 0. Can I use an IF statment for this? How would I do this? thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement
try this
=IF((C29-C26)=0,C29-C26,0) On Sep 19, 1:06*am, help! wrote: I am not sure what to do here. I have a worksheet and if C29 - C26 =0, I want the cell to dispay the amount (for example 20000 - 15000= 50000) but if it is <=0, I want the cell to display 0. Can I use an IF statment for this? How would I do this? thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement
You could also try
=(C29C26)*(C29-C26) The equation in first set of brackets returns 1 if true, 0 if false, and the equation in the second set of brackets is multiplied by that value Boatman "help!" wrote: I am not sure what to do here. I have a worksheet and if C29 - C26 =0, I want the cell to dispay the amount (for example 20000 - 15000= 50000) but if it is <=0, I want the cell to display 0. Can I use an IF statment for this? How would I do this? thanks! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement
Thanks this worked for the one cell, however when I used it another cell to
show the increase for example =IF((C29-C26)<=0,C29-C26,0) it returns the correct amount but with a negative sign in front. How do I get rid of the negative sign? thanks! "muddan madhu" wrote: try this =IF((C29-C26)=0,C29-C26,0) On Sep 19, 1:06 am, help! wrote: I am not sure what to do here. I have a worksheet and if C29 - C26 =0, I want the cell to dispay the amount (for example 20000 - 15000= 50000) but if it is <=0, I want the cell to display 0. Can I use an IF statment for this? How would I do this? thanks! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement
Well, if your current formula is returning a result of C29-C26 and that is
negative, what do *you* think the formula is which would give a positive number of the same magnitude? -- David Biddulph "help!" wrote in message ... Thanks this worked for the one cell, however when I used it another cell to show the increase for example =IF((C29-C26)<=0,C29-C26,0) it returns the correct amount but with a negative sign in front. How do I get rid of the negative sign? thanks! "muddan madhu" wrote: try this =IF((C29-C26)=0,C29-C26,0) On Sep 19, 1:06 am, help! wrote: I am not sure what to do here. I have a worksheet and if C29 - C26 =0, I want the cell to dispay the amount (for example 20000 - 15000= 50000) but if it is <=0, I want the cell to display 0. Can I use an IF statment for this? How would I do 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) | |||
| SUMIF statement with AND 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
