Help with a formula

Copper Contributor

I would like to add a formula to excel to represent something, for example if I input 1 then I want the result to be £1500, if I input 2 then I want the result to be £2250, if I input 3 then I want the result to be £3000 and if I input 4 or any value higher than that, I want the result to be £3500.

2 Replies

@NATODON 

=IF(C2=1;1500;IF(C2=2;2250;IF(C2=3;3000;IF(C2>=4;3500))))

You can try this formula.

Thank you - I will try