Excel – Nested If

How do i write a nested if statement for the following? 

If greater than  14 but less than 16 return £10000 
BUT If greater than  16 but less than 18 return £20000 
AND if greater than 18 return £30000

I tried =IF(AND(C9>=14,C9<16),10000,0)
Which returns £10000 however when i try nest it, everything just returns #VALUE?

Thank you

By: andrew garrard

Leave a Reply

Your email address will not be published. Required fields are marked *