Solved Need help with if formula

July 23, 2012 at 07:25:34
Specs: Windows XP
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

See More: Need help with if formula

July 23, 2012 at 08:11:50
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:


What caused this.

Report •

July 23, 2012 at 08:41:55
✔ Best Answer
If you are using the formula you posted, i.e. this one:


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 = Solutions

When 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.

Report •
Related Solutions

Ask Question