B
Bob
I'm sure there is a way to modify this formula but have no idea.I'd
like for it to do this:
=IF(A30="","",SUM(C3:C25)*ROUNDUP(Worksheet2!G3/G1,0)) which is fine.
But if Worksheet2!G3 has more than whats in G1 then MINUS Sum(C3:C12)
to the above formula. Example:
Worksheet2!G3 has the total Qty. Sheet1 has a number in it (25) For
every 25 this formula is dividing Worksheet2!G3 by 25. I want it to
divide only once, then Do formula Minus Sum(C3:C12) as many times as
G1 will go into it. Thanks in advance!!!
like for it to do this:
=IF(A30="","",SUM(C3:C25)*ROUNDUP(Worksheet2!G3/G1,0)) which is fine.
But if Worksheet2!G3 has more than whats in G1 then MINUS Sum(C3:C12)
to the above formula. Example:
Worksheet2!G3 has the total Qty. Sheet1 has a number in it (25) For
every 25 this formula is dividing Worksheet2!G3 by 25. I want it to
divide only once, then Do formula Minus Sum(C3:C12) as many times as
G1 will go into it. Thanks in advance!!!