Using a formatted value output in next formula

Questions and Help
1

Hi!
I'm finding it difficult to use the value from formatted output (,.2f)

I.e I have the value 47,9655, which is a result from a formula. In formatted output it shows as 47,97.

In the next formula I want to multiply the output value, and not the actual unformatted value.
Any ideas?

2

Hi @benjamin.tolfsen, sure, you will need to create an intermediary variable. here is the sample snippet.

{val1=47.9655; format=,.2f}
{val2={=val1; format=,.2f}}
{=val1}
{=val2}

Here, replace val1 with the output from the previous formula and use val2 in the next formula.

This can be further optimized, based on how you use the variables.

1 Like
3

Thanks! Works perfectly :slight_smile:

1 Like