Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website


Support
· Forums
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


  
NeoOffice :: View topic - Excel to Calc formula conversion problem
Excel to Calc formula conversion problem
 
   NeoOffice Forum Index -> OpenOffice.org MacOS X X11 Support
View previous topic :: View next topic  
Author Message
JDF
Guest





PostPosted: Wed Oct 29, 2003 12:25 pm    Post subject: Excel to Calc formula conversion problem

Hello all,

I am having a hard time figuring out how Calc deals with multiple IF statements.

In Excel I have a formula that looks like this:

=SUM(IF('Activity Log'!$F$5:$F$136='Time Sheet'!$A7,IF('Activity Log'!$B$5:$B$136='Time Sheet'!B$6,'Activity Log'!$H$5:$H$136)))

I just can not seem to figure out how to write the equivalent formula in Calc. If anyone could help it would be greatly appreciated. If we can get this doc converted (it's a time sheet,) then we can move forward with a pilot project to switch from MS Office over to OpenOffice.org.

Thanks for time.

john
Back to top
fred78
Agent


Joined: Sep 25, 2003
Posts: 13

PostPosted: Wed Oct 29, 2003 1:41 pm    Post subject:

Hi,

It looks strange to me...

Can you email me an example? (Excel)?

Fred <- f dot vuillod at free.fr
Back to top
OPENSTEP
The One
The One


Joined: May 25, 2003
Posts: 4752
Location: Santa Barbara, CA

PostPosted: Wed Oct 29, 2003 3:55 pm    Post subject:

The OOo format for the conditional IF uses semicolons to seprate condition; true_value; false_value. There's no implicit test for non-zero vaues, so if you're dealing with numerical information you may need to use an explicit "<> 0" in conditions.

e.g., formula

IF(A1 > 3; 5; 10)

When cell A1 contains 23, the formula evaluates to 5. If cell A1 contains 0, evaluates to 10.

ed
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> OpenOffice.org MacOS X X11 Support All times are GMT - 7 Hours
Page 1 of 1

 
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
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.