Hi,

I have a formula with two IF statements and would like to add a third and fourth i.e.


=IF(F10="","",IF(J10<=F10*0.1,"Warning 10% or less Budget Remains!",

IF(J10<=F10*0.2," Warning 20% or less Budget Remains!","")))

The first IF in the formula checks the value in cell J10 and if it is less or equal to10% than the value F10 a message will be displayed i.e. ‘Warning 10% or less Budget Remains!’.

The second IF in the formula checks the value in cell J10 and if it is less or equal to 20% than the value F10 a message will be displayed i.e. ‘Warning 20% or less Budget Remains!’.

What I would like for the third IF statement to check if the value in cell J10 and if it is equal to F10 a message will be displayed i.e. ‘No Budget Remains!’.

What I would like for the fourth IF statement to check if the value in cell J10 and if it is greater than F10 a message will be displayed i.e. ‘You have Exceeded Your Budget!’.


Any help would be great appreciated as I’ve tried and cannot get the syntax correct


Many thanks in advance


Rob

NB Excel version 2003