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 "absolute" (fixed), then place the "$" 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.