Formula conversions or new formula needed
Posted by Steve on October 10, 2000 9:04 AM
Hi, I'm working on converting a Lotus 1-2-3 worksheet into an Excel file. Now, for about 20-25 certain cells, the formulas didn't convert (i.e. "formula failed to convert"), and it's because there are more than 7 sublevels of the formula (i.e. 9 IF statements). I need to know how I can make this a working formula in Excel. Here is an Example of the conditions for one cell that need to be put into one working formula...
IF B58 >=100,000 AND <200,000, $D424
IF B58 >=200,000 AND <300,000, $E424
IF B58 >=300,000 AND <350,000, $F424
IF B58 >=350,000 AND <400,000, $G424
IF B58 >=400,000 AND <600,000, $H424
IF B58 >=600,000 AND <700,000, $I424
IF B58 >=700,000 AND IF B58 >=800,000 AND <1,000,000, $K424
IF B58 >=1,000,000, $L424, ""
I cannot shorten the amounts (i.e. take out 350,000) because the Lotus program uses those amounts all over the program. HELP!