formulas on formulas

Nynke
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
0 votes

Submitted · Last Updated

Comments

  • airplanebushotel
    airplanebushotel Member Posts: 4 VERIFIED MEMBER
    First Comment Photogenic

    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.