Formula

G

Guest

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

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

Peo Sjoblom

Try

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


Regards,

Peo Sjoblom
 
N

Neil

Try this formula:

=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,"")))))

I tested it out and it seems to work.

Good Luck!
Neil
 
D

Debra Dalgleish

What if the difference is exactly 10%?

for less than or equal to 10%
=B3*IF(ABS((D3/B3-1))<=0.1,1,IF(D3>B3,1.1,0.9))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Supress DIV/0 2
Excel Help to copy information from one row at a time to another sheet 1
Formula 4
If OR formula 1
Need a code 1
product code a value 0
need a formula 2
Need Help with Excel and Flagging Outcomes! 4

Top