LinkBack URL
About LinkBacks
= IF(B2 = C2, "PASS", "FAIL")
returns #NAME. I'm trying to compare two variables and if they match, have it return a PASS
Does anybody see an error in my statement?
Hope to hear from you soon,
-Jonathan
IF statement returning #NAME
= IF(B2 = C2, "PASS", "FAIL")
returns #NAME. I'm trying to compare two variables and if they match, have it return a PASS
Does anybody see an error in my statement?
Hope to hear from you soon,
-Jonathan
Hi,
Are you able to post the workbook? I have copied and pasted your formula into a sheet and it generates no error for me.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Apart from removing the spaces I cant see anything wrong.
Post the spreadsheet.
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Originally Posted by sweep
Is this good enough?
https://1drv.ms/x/s!At4b_T2RkzDNg8J69DODJwb38iEuPg
Aaah,alright.
Here you go.
Just some extra information, i added spaces after trying without them, as i thought maybe it needed spaces...
(Looked like it had spaces when i saw examples online while searching for the error.)
As stated before, remove the spaces.
It then works.
UPDATE: Actually it works if you press F2 to edit the formula and hit return leaving the spaces in.
There must be a spurious character in the formula that's not being displayed.
I don't think so, extra spaces can't bother the formula... May b Jona has copied the formula and pasted it into cell. If he will do edit with F2 and then enter it would work....
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Nah, i typed it out myself, I am a programmer.
Just not very good in excel^^
There's no extra characters, formula is 29 characters long and all non visible characters are spaces ASCII 32.
But as said hitting F2 and enter resolves the problem.
As you can see, even without spaces, it still doesn't work...
hahahah the excel understood, you are trying making something new thats why it return #NAME error.. BTW space is not a problem at all in any function of excel..... but when you will use any text function it can be change result.
.
You should write IF function in your native language.
May be IF=ALS
.
Last edited by yurttas; 04-13-2017 at 06:10 AM.
You must use ";" instead on "," .....
"You should write IF function in your native language."
This works, wow. Thank you!
I need to change back from Dutch to English lol...
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks