Nested if function

[Dannypak]

Hi hoping to get some help on doing a nested if function.
ROQ (re-order qty)
ORDMULT (order multiple)

trying to figure out how to write the forumula so that if:

If A>B=A but if differance between A&B=less than B, then it has to be a number that is multiple of B (i.e. if B=6 then it should be Actual ROQ=B*2)
If A<B=B,

Thanks for any help on this!

[Crooza]

Hi Mate

Can you tell me what you think the answer should be for the first few lines of your spreadsheet. I've done the A>B and A<B scenarios (please confirm this is what you want) but I don't understand your scenario when A-B > B (Or when A is greater than 2*B)

Please Login or Register  to view this content.

Oh and I don't think it needs to be a nested if either.

you can simply test for the A>2B, run your true formula when we understand what that is and then your false forumla will simply be max(a,b)

like

=if(A2>2*b2,[your formula],max(a2,b2))

[protonLeah]

Try: =IF(AND(A2>B2,ABS(A2-B2)>B2),A2,IF(AND(A2>B2,ABS(A2-B2)<B2),CEILING(A2,6),B2))

[mgd0903]

Your requirements are ambiguous. Re-submit the form with the manual answers.

[Crooza]

I think ProtonLeah has it. It's not how I understood what the OP asked for but her solution seems to be logical in that it orders the minimum order to cover the Reorder but in the appropriate multiples. Well done understanding that ProtonLeah

[Dannypak]

Thanks so much for figuring this out for me even though my explanation was not so great! Your formula works perfectly.

[Dannypak]

Thank you everyone!!