Forum Discussion
Solved
Excel If Formula
I am unable to formulate a formula to help me come up with house allowance using the following details. If the basic salary is < 30,000 then 23% or 3,000 whichever is higher. If basic salary is ...
With a basic salary in A2:
=IF(A2<=30000, MAX(23%*A2, 3000), IF(A2<=50000, MAX(20%*A2, 6900), MAX(15%*A2, 10000)))
This can be filled down if required.
With a basic salary in A2:
=IF(A2<=30000, MAX(23%*A2, 3000), IF(A2<=50000, MAX(20%*A2, 6900), MAX(15%*A2, 10000)))
This can be filled down if required.
The formula has worked perfectly. Thank you very much.