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 o...
  • Riny_van_Eekelen's avatar
    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. 

Resources