Dear All,
I have a formula as per below:
=IFERROR(IF(D3=0,0,IF(D3>2500,D3-(D3*$G$3%),IF(AND(D3<=2500,D3-(D3*$H$3%)<=100),D3-$F$3,D3-(D3*$H$3%)))),0)
B3 = net amount. This cell has the formula
D3 = Cost
F3 = 100.00
G3 = 10 (10%)
H3 = 25 (25%)
A) if cost is more than 2500 then net amount should be 2500-10%
B) if cost is less than or equal to 2500 then net amount should be 2500-25%
C) if cost is a) less than or equal to 2500 & b) cost - 25% is less than or equal to 100 then net amount should be cost-100
The formula seems to work fine for Point A and B.
For point C the formula seems to work fine. If the cost is 100 then net amount shows as 0.00, if the cost is 50 then net amount shows as -50.00. For cost between 100 to 133 the net amount shows the cost-100, however for some reason this only works fine for cost from 100 to 133 and if the cost is 134 and more, the formula shows the result as per point B
I will be thankful if someone can guide me to correct/amend the formula and explain the reason of this mis-calculation for point C.
With kind regards,
Bookmarks