Formula

[Kelly]

If it is possible I need a formula to do the following.

If D3 is >=B3 by 10% then C3 = (B3*10%)+B3.
If D3 is >B3 by less than 10% then C3=B3
If D3 is <=B3 by 10% then C3 = B3-(B3*10%)
If D3 is <B3 by less than 10% then C3= B3
If D3 = B3 then C3 = B3

I have tried both of the formulas below but when I put 100
in B3 and 95 in D3 it gives me 100 for C3. I need it to
return 95 since it is less than B3 by less than 10%.


=IF(D3>(B3*1.1),(B3*0.1)+B3,IF(D3>(B3*0.1),B3,IF(D3<
(B3*1.1),B3-(B3*0.1),IF(D3<(B3*0.1),B3,IF(D3=B3,B3,"")))))


=IF(D3-B3>B3*0.1,1.1*B3,IF(B3-D3>B3*0.1,B3*0.9,B3))

 

[duane]

try this

=IF(D3<=B3*0.9,B3*0.9,IF(D3<=B3*1.1,B3,B3*1.1)

 

[Kelly]

I get the same result. If I put 100 in B3 and 95 in D3
C3=100. I need it to be 95.

 

[duane]

If D3 is <B3 by less than 10% then C3= B3

this is what you asked for

b3=100, d3 =95 would seem to meet this condition

therefore c3=b

 

[Myrna Larson]

Then you need to change your criteria. I think you said the difference had to
be more than 10%. 95 is only 5% less than 100.