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.
Joined: May 25, 2003 Posts: 4752 Location: Santa Barbara, CA
Posted: 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.
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