IF logical statement

**kckid12** · 03-31-2009, 02:27 AM

I am trying to write an if statement can somebody please help me...

In row C3 all I have is the letter S

I need the if statement to say If c3=S then blah blah blah Everytime i enter

If logical statement and enter c3=S it tells me name# ?? How do I enter this to get this statement?

**DonkeyOte** · 03-31-2009, 02:37 AM

you must use quotations around text, ie:

=IF(C3="S",1,2)

would return 1 where C3 = "S" and 2 where not true.

**kckid12** · 03-31-2009, 01:35 PM

one final question

thank you for the help...

I need it to say If C3 = "N" is true then Multiply B5*4, if not then 0

How do I get it to multiply to cells once I have established a true/false statement in the IF logical