some_evil
New member
- Joined
- Feb 10, 2014
- Messages
- 10
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- 2019
Hi Guys, attached is a xlsx file with pipes in our government area, and I am trying to add a field that multiplies its unit rate by the length, which in turn gives us a total value for each pipe type. But when I manually calculate the values I am getting different results.
View attachment Current Sewer Main Types.xlsx
see formula im using:
see results i get vs excel calculates:
Is there a better way for me to be calculating these total values so they are correct?
Thanks heaps.
View attachment Current Sewer Main Types.xlsx
see formula im using:
see results i get vs excel calculates:
Is there a better way for me to be calculating these total values so they are correct?
Thanks heaps.