column/row | A | B | C | D |
1 | Item | Unit or pallet | unit per case | Total Case |
2 | Apple | 50 | 2 | 25 (=50/2) |
3 | Apple on a pallet | 4 | 2 | 8 (=4*2) |
4 | Orange | 8 | 4 | 2 (=8/4) |
5 | Orange on a pallet | 15 | 4 | 60 (=15*4) |
<tbody>
</tbody>
I want to use if formula to calculate for column D. what should the formula be?
I tried this but it didn't work.
=IF(A2="*"&"pallet"&"*",B2*C2,B2/C2)
Please help.