How do you get a difference of 2 numbers, then get a percentage of the total?

[anoble1]

Hi,

I have a number in Column D (1074.77) and a number in Column F (918.00). Difference is 156.77. In Column H is where I need the 10% of 156.77. How do I get a percentage of that number along with the difference of those columns?

thanks,

should come out to: 15.677

[Olly]

=(D1-F1)*10%

Is that what you want?

[AlKey]

Or this

=ABS(D1-F1)/100*10

this will work if D1 or F1 is greater

[anoble1]

Thanks, works great!

Or this

=ABS(D1-F1)/100*10

this will work if D1 or F1 is greater

[AlKey]

You're welcome and thank you for the feedback!

Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools -> Mark thread as Solved).