Forum Discussion
Andre0420
Aug 19, 2022Copper Contributor
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.
2 Replies
Sort By
- Riny_van_EekelenPlatinum Contributor
- Andre0420Copper ContributorThank you. it worked!