MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Create an If Statement With Multiple Calculations?

I am trying to create an if statement with multiple formulas and within those formulas round a number and create a percentage. That percentage will be used to calculate the cell value with another formula. Ex., If C6B6 then I want the formula to be C6*.1. I’m lost me head is spinning I need help!!
—–
Kyle K

Comments: 9 Responses to “How Do I Create an If Statement With Multiple Calculations?”

    5 years ago

    You use multiple IF functions, nested.
    So if you have condition A and condition B, then you can do:
    =IF(A,1,IF(B,2,3))
    This will return 1 if condition A is true. It will return 2 if condition B is true. It will return 3 if either of them is true.

    But it doesn't look like you need this.
    So yours will be something like this, though I'm not sure about the reason for your .1 multiplier.
    =IF(C6=B6.

    Kyle
    5 years ago

    The reason for the .1 multiplier is I am trying to get to a percentage. The base percentage that will be used is 10% how ever if the sold amount is under “par” the percentage must be recalculated by dividing C6 into A6. Which will return a .6578. I want .6578 rounded down to .6 which will be 6% and will be the new amount used to calculate the new value instead of 10%. So if I multiply by .1 then it will give me .06 for my math to work.

    Kyle
    5 years ago

    IF(Par '7/3'Contract Price '7/3',(Contract Price '7/3'÷Retail Price '7/3')×0.1×Par '7/3')) that what i have right now which I thought would work besides the routing down part which I don't know.

    Kyle
    5 years ago

    IF(Par '7/3'Contract Price '7/3',(Contract Price '7/3'÷Retail Price '7/3')×0.1×Par '7/3')) Sorry that didn't sent right the first time.

    5 years ago

    Kyle: So the third part of the IF function is what is returned if the answer is false. So add that third part. See my original reply. Rounding down can be done with FLOOR but it also can just be the format for the cell.

    5 years ago

    You can also watch https://macmost.com/using-the-if-function-in-numbers.html where I mention nested IF functions.

    Kyle
    5 years ago

    Apparently this comment won't sent greater and less than arrows. IF(Par is greater than ContractPrice then ContractPrice*.1(which is 10%) But if Par is less than ContractPrice (I need a new percentage calculated to multiply to Par) so IF(Par is less than ContractPrice then (ContractPrice/RetailPriceROUNDEDDOWN)*.01)*Par))

    5 years ago

    Kyle: Again, it doesn't sound to me like you need to nest IF functions at all. Just one simple IF function will do. Read the documentation in Numbers about the IF function or see my link in my last comment.

    Kyle
    5 years ago

    Thank you Gary!

Comments Closed.