If-Then Statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
In cell C1, put the formula:

=IF(A1="W",B1/4, IF(A1="BW", B1/2, IF(A1="SM", B1/2,
IF(A1="M",B1,"error?"))))

Regards

Trevor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF "value if false" not working 2
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX 6
I would like a formula that 1
Nameing a function 1
Copying a cell value to another sheet by using If statement 1
if function, how? 4
setting cell values based on a 3rd cell 4
Countifs with different restrictions 1

Back
Top