This formula is driving me crazy. Its a 3 step process. For one cell.
I need to add cell b + c + d
Then take that number and times by 200,000
then take that number and divide by a
Does anyone have an idea?
Solved! Go to Solution.
Following radzmar instruction above to change the code to be
I have made the modifications and uploaded the file here https://acrobat.com/#d=gv3yzm73ZD-8gb-hPOlVbQ
Can you try that document and see if it works for you, this works for me, when
a != 0
b,c,d,e can be 0
Hope this helps
This error appears, because one of your values is 0.
A division with 0 returns always 0 and the script fails.
So, to avoid the error, you can wrap you formula into an if expression.
that was what I'm asking for.
If any of the values (a1 to e1) is null (empty) the script fails.
So, you need a more specific expression for you formula.
In TIR1 add:
and in LTA1 add: