Hi everyone,
I am trying to calculate the bodyfat%, but the expression (see below) is not working. I get the error message: POWER has invalid inputs. Anyone can help me here?
Thx Robert
0.483*((7.811*POWER([Körpergewicht],-0.288))*(0.304*POWER([Körpergröße],0.362))*POWER((ABS([SUMME]-((11.278*POWER([Körpergröße],-0.725))*POWER([Körpergewicht],0.575)+40)),0.5)))+(-0.006)
Solved! Go to Solution.
You have redundant paranthesises:
0.483*
(
(
7.811*POWER([Körpergewicht],-0.288)
)*
(
0.304*POWER([Körpergröße],0.362)
)*
POWER(
ABS(
[SUMME]-((11.278*POWER([Körpergröße],-0.725))*POWER([Körpergewicht],0.575)+40)
)
,0.5
)
)+
(-0.006)
You have redundant paranthesises:
0.483*
(
(
7.811*POWER([Körpergewicht],-0.288)
)*
(
0.304*POWER([Körpergröße],0.362)
)*
POWER(
ABS(
[SUMME]-((11.278*POWER([Körpergröße],-0.725))*POWER([Körpergewicht],0.575)+40)
)
,0.5
)
)+
(-0.006)
Thx Levent,
that was it!!
BR. Robert
@Robert
You can also shorten your expression:
(
1.146904752*
POWER([Körpergewicht],-0.288)*
POWER([Körpergröße],0.362)*
POWER(
ABS(
[SUMME]-((11.278*POWER([Körpergröße],-0.725)*POWER([Körpergewicht],0.575))+40)
)
,0.5
)
)
+
(-0.006)
Hi Levent,
sorry for bothering you again. I have an issue and I have no clue why Appsheet is calculating this different from excel:
([Körpergewicht] * DECIMAL((100.00 - [Körperfett]) / 100.00))
In this formula above the Körperfett = 16,9 and Körpergewicht = 81,4, expected result from this formula is 67,6, but Appsheets result is: 81,3.
I have no Idea how Appsheet is calculating this and what I am doing wrong.
In the meantime i created this topic: Cacluclation of an expression is different from expecting result
Thx.
Robert
@Robert
It seems it’s calculating correctly:
[Körpergewicht] * (1 - [Körperfett] / 100.00)
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |