I am trying to create a formula that states if cell C3 contains the word "Solutions" then the account number is 10-100 and if not then leave blank but I cannot get it to work. Here is what I have: =IF(C3=Solutions), 10-100"," ")

Since that did not work, I tried

=IF(C3="Solutions"), 10-100"," ")What am I missin??? It keeps coming back with a NAME or FALSE error message

Update, I got the fomula to work wihtout an error message but instead of giving me a return value of 900 versus 10-100. Here is what I changed it to:=IF(C3="Solutions",10-100,"-")

What caused this.

If you are using the formula you posted, i.e. this one: =IF(C3="Solutions",10-100,"-")

then I don't see how it could be returning 900.

It can only return 2 things:

A dash when C3 <> Solutions

-90 when C3 = SolutionsWhen C3 = Solutions, Excel will perform the mathematical operation 10 - 100 which equals -90.

If you want 10-100 to appear in the cell, you must enclose the string in quotes so that Excel treats it as text.

=IF(C3="Solutions", "10-100", "-")

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History