K
KevinM
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
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