[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
lucidmumbler
Newbie

Joined: 29 Sep 2006
Posts: 2

 Posted: Fri Sep 29, 2006 7:56 am    Post subject: do not calculate cells unless data is entered Hello all! I've recently moved from Excel and Word to the Openoffice suite and have to say I am mightily impressed and am determined that NO setbacks will send me with my tail between my legs back to the M\$ packages... hehe I had one problem which I'm working on thanks to searching on this forum and will soldier on with it before I ask for help. it's the best way to learn... however, I have a problem which to be honest has been carried over from Excel. How NOT to perform a calculation in a cell until values have been entered in the relevant cells it acts upon... so I have 2 cells which make a simple calculations. cell1 - contains the date that work is received cell2 - contains the date work was sent back cell3 - calculates the target date for sending work back (cell1 + 14 days) cell4 - calculates the differnce in days between cell2 and cell3 how do I stop cell3 aqnd cell4 from performing their calculation (ie. remaining blank) until all other required cells contain valid data? I guess this sounds naive but I'm new to spreadsheets. Thanks in advance!
RickRandom
Super User

Joined: 27 Jan 2006
Posts: 1082
Location: UK

 Posted: Fri Sep 29, 2006 8:18 am    Post subject: replace your existing cell with =IF(ISBLANK(cell with or without data);"";your existing calculation)
DiGro
Super User

Joined: 02 Jun 2004
Posts: 1210
Location: Hoorn NH, The Netherlands

Posted: Fri Sep 29, 2006 8:18 am    Post subject:

See if you can do something with this in D1

 Code: =IF(ISBLANK(B1);"";DAYS(C1;B1))

and

 Code: =IF(ISBLANK(A1);"";A1+14)

in C1

EDITED: Sorry RICK, you beat me to it
_________________
DiGro

Windows 7 Home Premium and OOo 3.3 NL (Dutch)
lucidmumbler
Newbie

Joined: 29 Sep 2006
Posts: 2

 Posted: Fri Sep 29, 2006 8:46 am    Post subject: brilliant thanks both for the speedy replies - isblank! all this time I've been without this function, now I won't be able to live without it! Thanks yet again! Effusive thanks I know but I really am grinning like a cheshire cat!!
DiGro
Super User

Joined: 02 Jun 2004
Posts: 1210
Location: Hoorn NH, The Netherlands

 Posted: Fri Sep 29, 2006 1:06 pm    Post subject: My (and probably our) pleasure. Have fun with OOo, I know I do _________________DiGro Windows 7 Home Premium and OOo 3.3 NL (Dutch)
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
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