Results 1 to 1 of 1
2008-05-29, 17:07 #1
- Join Date
- Jan 2004
- Pontiac, Michigan, USA
- Thanked 0 Times in 0 Posts
Combine Vlookup & Mod Formulas (2007)
Would someone be able to show me how to combine the formulas in F6 and G6?
The idea is to make sure that the quantity ordered is a multiple of the standard pack. Everything does work as it stands. However, I would like to have the formulas combined. Can this be done? If so, how?
On Edit: Never mind. I got it to work this time. Here's what I came up with:
=IF(MOD($C6,VLOOKUP(Order!A6,PriceList!$A$1:$D$4,4 ))=0,"OK","Change Pack Qty")