Lotus 123 @if(and statement 1

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 "a", "b", "c", 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 "a1". I you should want to use something like "a1", used the "_" character - e.g. "_a1" or "a1_".

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

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.