HI all
i would like an excel formula that would generate for me what it says in column G
thanks
i would like an excel formula that would generate for me what it says in column G
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | ITEM | DESCRIPTION | COST | PRICE LIST 1 | PRICE LIST 2 | PRICE LIST 3 | RESULTS | |||
2 | 11111 | BANANAS | $ 21.50 | $ 50.36 | $ 20.00 | $ 65.30 | PRICE LIST 2 IS LOWER THEN COST | NEED FORMULA TO GENERATE COLUMN G | ||
3 | 22222 | PEARS | $ 20.58 | $ 12.36 | $ 50.00 | $ 10.00 | PRICE LIST 1 & PRICE LIST 3 IS LOWER THEN COST | |||
Sheet1 |
thanks