This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello the community,
my table has a list of projects (one line per project) with monthly income and a number of months, thus calculating the yearly income per project (one column for monthly amount and one column for number of months) and per year if...
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 form...
Kuovonne,
You were 100% correct. No need to use the SWITCH instruction (even though I learnt something new!).
My IF formula works exactly as I needed it to.
Thank you again for your help, very instructive.
François
thank you very much Kuovonne! it helps.
the first condition of the formula works.
I still need the second condition in the formula
should the formula continue with:
OR IF ( {customer billing = “direct”, {indirect total sales revenue}) ?
Thank you aga...
thank you very much! it helps.
the first condition of the formula works.
I still need the second condition in the formula
should the formula continue with:
OR IF ( {customer billing = “direct”, {indirect total sales revenue}) ?
