Forum Discussion

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 o...

excel

Formulas and Functions

Riny_van_Eekelen
Aug 19, 2022
Andre0420
=IF(C3="Case",B3*164,B3*10)
If it's always Case or Bottle in C, this will work just fine.

Riny_van_Eekelen

Platinum Contributor

Aug 19, 2022

Andre0420

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

If it's always Case or Bottle in C, this will work just fine.

Andre0420

Copper Contributor

Aug 20, 2022

Thank you. it worked!