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 Microsoft's new Surface Go will be a hit?

Discuss in The Lounge

Poll History