I'm trying to covert a Lotus formula to Excel but have run into problems with multiple nested IF formula's (to many)... The formula works in Lotus but not Excel. I'm sure there is a more efficient way to find the values using Arrays or Lookups can anyone help? The following is the Lotus formula I'm trying to convert or make more simple in Excel: @IF(B5=""," ",@IF(B7>B26#AND#B7>B35,0,@IF(B7=B26#AND#B7>B35,0.5,@IF(B7-B35#AND#B7>B26,0.5,@IF(B7>B26#AND#B7<B35,1,@IF(B7>B35#AND#B7<B26,1,@IF(B7=B26#AND#B7=B35,1,@IF(B7=B35#AND#B7<B26,1.5,@IF(B7=B26#AND#B7<B35,1.5,@IF(B7<B26#AND#B7<B35,2," "))))))))))

In Excel, you are limited to 7 Nested IF's within one formula. If you Google something like Excel Nested If 7, you'll find a number of of sites offering alternatives to Nested IF's. Here's just a couple: http://www.j-walk.com/SS/excel/user... http://www.cpearson.com/excel/neste... Since you know more about what you are trying to do than the rest of us, for now we'll leave it up to you to search these sites for an alternative. Feel free to come on back if there is anything specific related to one of the alternatives that we can help with. Good luck!