Thread: Nested If statement

Within a nested IF function can I incorporate a basic sum ? The formula I'm using is -

=IF(C6>B6,"increase",(IF(C6<B6,"decrease",IF(C6=B6,"no change",""))))

Where the statement is either increase, decrease I want to inoput the actual change i.e the diference between c6 and b6 for example.

Any help would be greatly appreciated, and if this has been answered anywhere else I apolgise for re posting

Thanks again

Originally Posted by zbor

maybe =IF(C6=B6,"no change",C6-B6)

Whilst this gives me the "Change" in value I need to say whether this is an increase or decrease.

eg.

0.50% Increase

Thanks

Originally Posted by zbor

How about this:

=IF(C6>B6,TEXT(C6/D6-1, "0,00%")&" increase",IF(C6<B6,TEXT(C6/D6,"0,00%")&" decrease","no change"))

A bit confused now as I am now getting #DIV/0, and I was not looking at anything in column D.

Sorry, if I am being stupid as part of jmy worksheet I have 2 columns "B" containing last months data and "C" containing this months data, I have an IF function that illustrates using an arrow either up down or sidewards what this months change is. However I need to replace this with a basic statement ie. 0.5% increase, 2.25% decrease, or no change. I'm not sure whether your last reply would solve this or not ?

Thanks again for you help

Originally Posted by zbor

Yes, sorry, mystyped...

=IF(C6>B6,TEXT(C6/B6-1, "0,00%")&" increase",IF(C6<B6,TEXT(C6/B6,"0,00%")&" decrease","no change"))

Of course you get DIV/0 since D6 was 0.

Thanks, this looks like it should work, I need to look again at work tomorrow however I just tested it and it seems fine.

Thanks again