On Fri December 30 2005 19:43, + Braswell, Brian wrote: > [ MODERATED ] *********************** > Hi, > I recently installed your Open Office suite hoping that it would fix the > problems I was having with Microsoft Excel - however, they just got much > worse. > > I opened up a spreadsheet in your open office calc spreadsheet program and > the multiple If/Then statements were apparently not valid in your program. > So, I tried to use your help guides to rewrite them. They are very complex > and generally not helpful. Does your program even support multiple if/then > statements, random 1 through 10, random 1-100 statements??? So far, I > can't seem to find that they do as they all became blank statements with > errors. My if/then statements tend to be 5 to 7 variables long - so any > help would be greatly appreciated. > > Your guides are not clear and the examples are totally incomprehensible. > Please explain this to me or show me a link that takes me to a much more > concise tutorial with more logical examples than your help guides have.
As you are not subscribed you may not have seen that: On Fri December 30 2005 23:04, Joe Conner wrote: > If/Then statements take the form =IF(condition;true;false). > > Nested If/Then statements take the form > =IF(1st condition ; > IF(2nd condition ; 1st and 2nd true ; 1st true, 2ndfalse ) ; > IF(3rd condition ; 1st contition false, third condition true ; 1st > condition false and 3rd condition false) ) > > Example: put 1 in a1, 2 in a2, 3 in a3, and in a4 put the equasion: > =IF(SUM(A1:A3)>6; IF(SUM(A1:A3)>10;">6 >10"; ">6,<10" ) ; > IF(SUM(A1:A3)>4;"<10, <4";"<=3")) > > now you can play around with the values in a1, a2, and a3 and see the > results change in a4. Please reply to [email protected] only. -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
