Lotus 123 @if(and statement 1

[jessec3]

Question:

I have a need to test for 3 or more conditions in a spreadsheet exif(a=1 and @if( b=2 and @if( c=3, then "x", else "y&quot)).

Also have a need to test conditions within a range of #'s
ex: @if(a>20 and @if(a<=25,then x, else y))

Any help would be greatly appreciated.

 

[DaleWatson123321]

Hi Jessec3,

If you haven't yet started to used range names, then I would STRONGLY recommend that you start now. You'll see that it will make a HUGE difference in your overall use of Lotus 123.

Where you referred to &quot;a&quot;, &quot;b&quot;, &quot;c&quot;, etc, I have used 3-digit names. You can use whatever name you like - usually one will use names that you can associate with the data. Be sure NOT to use names that will conflict with cell coordinates. For example, don't use a name like &quot;a1&quot;. I you should want to use something like &quot;a1&quot;, used the &quot;_&quot; character - e.g. &quot;_a1&quot; or &quot;a1_&quot;.

Here are the formulas...

1) @IF(AAA=1#AND#BBB=2#AND#CCC=3,XXX,YYY)

2) @IF(AAA>20#AND#AAA<=25,XXX,YYY)

If you want to copy these formulas and have the reference to the range names stay &quot;absolute&quot; (fixed), then place the &quot;$&quot; character in front of those names you want to stay absolute.

I hope this helps. Please advise as to how you make out.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[jlipari]

I was unable to repair the file. I ended up having someone re-create the spreadsheet for me. I would like to know if there is a way to repair them in case it happens again though.