Hi

Can anyone help me, i'm trying to put together a nested IF formula and it looks like this at the moment

=IF(A28="standard carer hourly rate",10.16,IF(A28="registered nurse rate",15.24,IF(A28="waking night carer rate",12.7,IF(A28="Enhanced Carer Hourly rate",11.43,0))))

It works for all the options on the validated drop down menu except Enhanced Carer Hourly Rate which always comes back as 0 rather than 11.43. I really can't see where I've gone wrong and I've checked spellings as well it's very frustrating as it works perfectly for the other choices.

Can anyone help?