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