NickVan_Laar

2 years agoQrew Member

# My formula doesn't work

Hello! I am admittedly new to quickbase. I am having problems with my formula in a table not working.

For instance, if I enter:

RB1 = 80.8

RB2 = 80.4

RB3 = 80

RB4 = 80.6

System Discharge = 140

This should yield: 1.161

Am I inputting the formula wrong or missing something? Using the wrong nomenclature?

I worked this formula out in Excel first and verified it works then transferred it to quickbase:

Any help is appreciated! Thank you!

------------------------------

Nick Van Laar

------------------------------

`(10^(6.67956-(1002.711/(((Average([Return bend Temp 1],[Return bend Temp 2],[Return bend Temp 3],[Return bend Temp 4])+459.67)*0.145)-14.7))))-[System Discharge Pressure]`

"Return Bend 1, Return Bend 2, Return Bend 3, Return Bend 4 and System Discharge Pressure" are all user inputs. For instance, if I enter:

RB1 = 80.8

RB2 = 80.4

RB3 = 80

RB4 = 80.6

System Discharge = 140

This should yield: 1.161

Am I inputting the formula wrong or missing something? Using the wrong nomenclature?

I worked this formula out in Excel first and verified it works then transferred it to quickbase:

`=(((POWER(10, (6.67956-(1002.711/(((A2+459.67)*(5/9))-25.215)))))*0.145)-14.7)-D1`

Any help is appreciated! Thank you!

------------------------------

Nick Van Laar

------------------------------