Minimum Wage Rise

[dj120374]

I am trying to create a formula to allow me to show new increases to the minimum wage in the UK.

So someone under the age of 18 will earn £6.95 just now but after 1st April will earn £7.05
and someone over the age of 18 will earn £7.20 just now but after 1st April will earn £7.50

Now I can change these using this formula:

=IF((AND(E2=7.2, E2>=6.95)), "7.5", "7.05")

but I also have staff that earn above the minimum wage and theirs will remain the same, but I can't get the formula to work for that.

Any help would be much appreciated.

 

[Gerald Higgins]

I suspect you DON'T actually want to test that

E2=7.2
AND
E2>= 6.95

Think about it, if E2 = 7.2, it HAS to be >= 6.95.

What do you REALLY want to do ?

Perhaps you want to say
IF AGE < 18 AND current wage is < 7.05, make it 7.05, otherwise leave it unchanged.

In which case something like this

=IF(AGE<18,MAX(E2,7.05),MAX(E2,7.5))

Replace AGE with the cell that contains the AGE.
Assumes E2 contains current wage.
Adapt as appropriate.

 

[dj120374]

Thanks Gerald, got it now:

=IF(I2=7.2,"+0.30",IF(I2=6.95,"0.10",IF(I2>7.2,"0.00",)))+I2