Possible to do?
If vendor AP, 1box = $1, if AM1Box = $2
i had few box size with diff price.
the formula will be at Column C based on Column A
or should use match?
If vendor AP, 1box = $1, if AM1Box = $2
i had few box size with diff price.
the formula will be at Column C based on Column A
or should use match?
BP_Actual Qty & Costs_2021 (as @ 14Oct21).xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | 1 box | Vendor | 1 box | ||
2 | 1 | AP | $ 1.00 | ||
3 | 2 | AM | $ 4.00 | ||
4 | 10 | AP | $ 10.00 | ||
Sheet1 |
Last edited: