i have the following colums that iam trying to combine in a formula :
- customer billing (with only two possibles choices: direct or indirect)
- indirect total sales revenue (a formula which multiplies a monthly amount by a number of months)
I need a formula in a new column which combines the two following conditions:
IF “indirect” is chosen, then copy the same amount
IF “direct” is chosen, then apply a 12% on the “indirect total sales revenue”
i hope it is clear enough.
Thyank you very much in advance!