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] 

formula

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


Joined: 29 Mar 2012
Posts: 1
PostPosted: Thu Mar 29, 2012 4:15 pm    Post subject: formula Reply with quote
i get a wrong data type. this formula is for a time study. can someone help? here is the formula.

=IF(A1:A100="","",IF(B1:B100="",NOW(),B1:B100))


thanks
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 8979
Location: Lexinton, Kentucky, USA
PostPosted: Thu Mar 29, 2012 8:28 pm    Post subject: Reply with quote
=IF(A1:A100="","",IF(B1:B100="",NOW(),B1:B100))

You can't put an array of cells into a single cell.
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