Show difference between values as a percentage
I am trying to create a formula to show, as a percentage, the difference between a sum and an entered value. So far I haven't quite been able to make one on my own. I keep a gas mileage logbook, and wanted to be able to see how accurate the pumps are, if they're running below what you're paying for!
If E (8.309 gals) * F (2.469 pump price) does not equal the entered value of column G amount paid $20.51, show the resulting difference in column H as a percentage.
Have a look at the attached Excel table and see if you can help me with this one.
Hi Gkitf16, welcome to the forum.
Is this what you're after?
=ROUND(E2*F2,2)/G2
Format that cell as percentage.
The display is completely accurate (gallons measured * price per gallon). That tells you nothing about how accurately the gas was measured.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks