OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

[SOLVED] NAME error using IF function, ref cell has > fun

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
vr6gtiguy
Newbie
Newbie


Joined: 20 Apr 2009
Posts: 2

PostPosted: Mon Apr 20, 2009 8:58 am    Post subject: [SOLVED] NAME error using IF function, ref cell has > fun Reply with quote

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
View user's profile Send private message
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Mon Apr 20, 2009 9:10 am    Post subject: Reply with quote

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
View user's profile Send private message
vr6gtiguy
Newbie
Newbie


Joined: 20 Apr 2009
Posts: 2

PostPosted: Mon Apr 20, 2009 9:32 am    Post subject: YEAH! Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group