For Cell C1: IF Cell A1= "W", Then C1=B1/4.
IF Cell A1= "BW", Then C1=B1/2
IF Cell A1= "SM", Then C1 = B1/2
IF Cell A1= "M", Then C1 = B1


How do I write an if statement in C1 so that it will return these varied
values of B1 depending on the text in A1? Thanks