Hi. I am trying to make a formula to figure out barrels of oil. This is the formula I have come up with for excel.
2.76*((topfeet*12+topinches)-(bottomfeet*12+bottominches))
Ex. 2.76*((6*12+10.25)-(1*12+5.25)) = 179.4
This seems to work in Excel but not on TapForms. All is comes up with is 0.000000.
I have tried to do this in more than one calculation but when I try to do a calculation on other calculations they aren’t there to select. Am I doing this wrong? Please help.
Hi,
Tap Forms can’t use calculation fields within calculation field formulas.
Can you email me your form template and I’ll take a look at the formula to see why it’s not functioning properly?
Send it to support @ tapforms.com
Thanks!
Brendan
.
