Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to return the following with an IF statement but I can not
get it to work. I don't know if the IF statement is the correct formual to use so any help would be appricated. I am trying to say the statring month is the default value (ie $400). If a month has a negative amout greater than the sum of the previous months it only returns a value of the negative of the sum (ie $400+ $400= $800, -$2400 for Mar, so really it is -$800). If it is greater than the first month it only counts the default value and not the higher value (ie $600 is really $400). If it doesn't meet any of those critera than it is just the value for that month. Jan Feb Mar Jan Feb Mar Total $400 $400 -$2400 $400 $400 -$800 $0 $400 $400 -$200 $400 $400 -$200 $600 $400 $400 $600 $400 $400 $400 $1200 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
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 |