formula for 2 different scenarios

[Montgomery]

Need to create a formula to capture 2 possible senarios
1) if cell is greater than .8999% then a 2% bonus on overall total
2) if cell is less than .8999% then a 2% penalty on overall total
There is no problem with #1 as it reads =if b13> .8999, b23*.02
I can't get # 2 to work on it's own or together.
Help

[mrice]

Try

Please Login or Register  to view this content.

You don't say what should happen if B13 = 0.8999.

[darkyam]

What do you want to happen if it's exactly .8999%?
=IF(B13>=.8999,.02,-.02)*B23
This will apply the bonus if B13 is exactly .8999%. Remove the second = to get it to apply a penalty at exactly .8999%.

[darkyam]

mrice, your formula will actually return a higher value if there's a penalty. It should be 1.02 rather than .02 with your logic, which make it the total value after either bonus or penalty.