| View previous topic :: View next topic |
| Author |
Message |
vr6gtiguy
Newbie
Joined: 20 Apr 2009
Posts: 2
|
 Posted: Mon Apr 20, 2009 8:58 am Post subject: [SOLVED] NAME error using IF function, ref cell has > fun |
 |
|
Hello,
I have not posted before as I can usualy find an answer with a search. Here is my problem.
I have a cell (O6) with this formula: =(N6>M6) Currently the output is TRUE
I have another cell with this formula: =IF(O6=1;yes;no) I am getting #NAME?
The first formula is in O6. I have tried a few variations in both cells and no luck. Does anyone have an idea on this one?
Last edited by vr6gtiguy on Mon Apr 20, 2009 9:31 am; edited 1 time in total |
|
| Back to top |
|
 |
RickRandom
Super User
Joined: 27 Jan 2006
Posts: 1082
Location: UK
|
| Posted: Mon Apr 20, 2009 9:10 am Post subject: |
|
|
Unless yes and no are named cells, then you need to use speech marks within the formula:
=IF(O6=1;"yes";"no")
Let us know if this helps or not. |
|
| Back to top |
|
|
vr6gtiguy
Newbie
Joined: 20 Apr 2009
Posts: 2
|
| Posted: Mon Apr 20, 2009 9:32 am Post subject: YEAH! |
|
|
Yes, that was it!
I was so sure it was the front of the formula, I neglected the back of the formula.
Thanks a bunch! |
|
| Back to top |
|
|
|
