Forum Discussion

Andre0420's avatar
Andre0420
Copper Contributor
Aug 19, 2022
Solved

If Then Else

Hello, i am a store keeper and i am making an inventory sheet for my store.

 

situation: I have an inventory sheet and in column C, i have Bottles and Case as units. in Column B, I have the count of items. There are different prices per Unit. i wanted to show the Total cost of my inventory in column E. 

 

=IF(C3="Case",(B3*164),0)("Bottle",(B3*10),0)

 

my formula is incomplete is not working. please help.

 

Resources