formulas on formulas
Nynke
Member Posts: 2 NEW MEMBER
my company has to calculate the quote with more than 1 formula. Now is it not possible to calculate with a number that was already calculated earlier. This means no formula can be done on a number what comes out of a formula. This is easy stuff what Excel does have.
Can you create this?
0
Comments
-
The work around I use is putting existing formulas inside the new formula. Example:
Formula 1 - A+B+C
Formula 2 - (A+B+C)*D
Formula 3 - ((A+B+C)*D) / E
Annoying especially on the more complex formulas but it is what it is.
0