multiplying a product by a different percentage based on a positive or negative number

[axlegrease99]

Hello, i have a spreadsheet that i use to compare projected costs to actual costs. Column C are projected costs, column B are my actuals, and i want column D to have the difference multiplied by a certain percentage based off of a positive or negative return. I would like the difference in these amounts to be multiplied by 110% if its a positive number and 100% if its a negative number. What kind of code would i have to write in column D to achieve this?

Thanks!

 

[Joe4]

Welcome to the Board!

Since the factor you multiply by depends on if the difference is positive or negative, we need to know how exactly the difference is being calculated.
Should the difference be column B minus column C, or the other way around (column C minus column B)?
It isn't quite clear which way it should go from the question.

 

[axlegrease99]

my apologies, it should be column B minus column C.

Thanks for your help!

 

[Joe4]

OK, see if this formula does what you want (place in cell D2):

=IF(B2>C2,(B2-C2)*1.1,(C2-B2))

 

[axlegrease99]

it worked on the instances where there was a positive number return but not when there is a negative number. This is what it returned. i would want the $300 to show as a -300.

[TABLE="width: 249"]
<tbody>[TR]
[TD="class: xl63, width: 72, align: right"]$900.00[/TD]
[TD="class: xl63, width: 79, align: right"]$1,200.00[/TD]
[TD="class: xl63, width: 98, align: right"]$300.00[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Sorry, I had the subtraction in last argument reversed.
Try:

=IF(B2>C2,(B2-C2)*1.1,([COLOR=#ff0000]B2-C2[/COLOR]))

 

[axlegrease99]

Solved.

Thanks a lot!

 

[Joe4]

You are welcome.