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 C6
—–
Kyle K
MacMost Q&A Forum • View All Forum Questions • Ask a Question
How Do I Create an If Statement With Multiple Calculations?
Comments: 9 Responses to “How Do I Create an If Statement With Multiple Calculations?”
Comments Closed.
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.=B6.
So yours will be something like this, though I'm not sure about the reason for your .1 multiplier.
=IF(C6
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.
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.
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.
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.
You can also watch https://macmost.com/using-the-if-function-in-numbers.html where I mention nested IF functions.
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))
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.
Thank you Gary!