Numbers formula yielding one of three markup values

need an Apple numbers table formula that yields one of three things:

IF D17≤2500 then value of cell should be D17÷ 6

But IF D17 > 250O and ≤ 5000 then the value of cell should be D17÷ 7.6664

But IF D17 >5000 then the value should be D17÷ 11


this lets me tell wholesale clients what the deduct as “theirs” on my invoice depending upon whether the retail was marked up 20%, 15%, or 10%

iPad Air

Posted on Feb 25, 2024 6:26 AM

Reply
Question marked as Top-ranking reply

Posted on Feb 25, 2024 6:41 AM

=IFS(D17<=2500, D17/6, D17<=5000, D17/7.6664, TRUE, D17/11)


In English: If D17<=2500 then D17/6 else if D17<=5000 then D17/7.6664 else D17/11

2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Numbers formula yielding one of three markup values

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.