Hi,
=IF(AND(A1>500001,A1<=750000),12500+(A1 -500000)* 10%,"No")
The result of above formulae if A1= 624000 will be 24900. To this 24900 I need to add 4% so that I get output of 25896 which I would like to divide by 12 which gives me value of 2158.
How to alter this formulae to achieve desired result
Bookmarks