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