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.
Bookmarks