Lotus to Excel formula conversion

sparkp088, on Tuesday June 10, 2008 02:28:07 PM

Hello,

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," "))))))))))

Configuration: Windows XP
Internet Explorer 6.0

Reply to sparkp088 Report this message to moderators Go to last message

This message seems useful, vote!
Report this message to moderators

tonyclark231, on Tuesday June 10, 2008 04:17:14 PM

hello

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!

Reply to tonyclark231

Ask your question Reply

Results for

Lotus to Excel formula conversion p Hello, I'm trying to convert a lotus formula to excel but have run into problems with multiple nested IF formula's 9to many)... The formula works in Lotus but not Excel. I'm sure there is a more efficient way to find the values using... en.kioskea.net/forum/affich-4843-lotus-to-excel-formula-conversion-p

Firmnual Help If cell is blank go to next ce Hello, EXCEL FORMULA If cell is not blank automatically look go to next cell (across) and if the cell has text in it the show the text ? I have 35 colums some have info (dates) and some do not I am trying to show the last intry in the colum at the... en.kioskea.net/forum/affich-26805-firmnual-help-if-cell-is-blank-go-to-next-ce

Countif with 2 criteria Hello, I am a teacher.If i want to calculate the number of students with who has marks between ,let's say 0 to 29, what excel formula do I use. en.kioskea.net/forum/affich-24124-countif-with-2-criteria

1 2 3 Next

Results for

How to convert Excel into PDF?How to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. PDF995 is software that gets installed on your computer which enables you to print any sources of document to PDF.... en.kioskea.net/faq/sujet-552-how-to-convert-excel-into-pdf

Excel tips : How to insert date In an Excel cellExcel tips : How to insert date In an Excel cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press “CTRL”+ “;” in the chosen cell. To insert current... en.kioskea.net/faq/sujet-313-excel-tips-how-to-insert-date-in-an-excel-cell

Publish a PDF file on your websitePublish a PDF file on your Website Proposing a PDF link on your own website is an operation that can seem quite easy if you are a professional webmaster and know how to effectively use HTML tags. For beginners in HTML, a PDF file can be... en.kioskea.net/faq/sujet-569-publish-a-pdf-file-on-your-website

1 2 3 Next

Results for

Adding a cell in a list using Excel FormulaHello, I need help using Excel. I would like to add a cell into a list if a value of the previous cell is greater than 0xFF. Here is what I need it to look like: $00 $24C0 $D2 $00 $C0 $24 $D2 Does anyone know of a formula or macro that I could use?... en.kioskea.net/forum/affich-20896-adding-a-cell-in-a-list-using-excel-formula

Excel FormulasHello, I am having difficulty copying fromulas on excell from different sheets to form an analysis page. I have 52 different sheets and need to copy the formulas to an analysis sheet so that i have the amount of each sheet on one page but for it to... en.kioskea.net/forum/affich-30063-excel-formulas

Excel formulasHello, I just create a database on excel , it is a daily record for my internal production , I would like to link some sheets together and get a recap of total sum in another sheet what is the correct formulae to be use for linking sheets? and also i... en.kioskea.net/forum/affich-12950-excel-formulas

1 2 3 Next

Results for

Download Excel ViewerWith Excel Viewer, you can open, view, and print Excel workbooks, even if you don't have Excel installed. You can also copy data from Excel Viewer to another program. en.kioskea.net/telecharger/telecharger-52-excel-viewer

Download DoPDF DoPDF is a converter of file PDF with personal or commercial usage. By using this program, you will be able to create files PDF by choosing order "impression " from any application.In a click, convert your documents Excel, Word or PowerPoint or else... en.kioskea.net/telecharger/telecharger-143-dopdf

Download Switch File Format ConverterSwitch is an utility of audio conversion for Windows. Switch is very easy to use. It is enough to add the file to convert in the list, to choose desired format and to clicker conversion on the button.It inserts a simple and intuitive interface. The... en.kioskea.net/telecharger/telecharger-785-switch-file-format-converter

1 2 3 Next

Results for

Spreadsheets - Cell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. An entire line can be chosen by clicking directly on the line header: It is also possible to choose... en.kioskea.net/tableur/tabcellselect-1.php3

Email - Mailing lists A mailing list is one of the most commonly used services on the Internet, allowing people to send messages to one or more recipients. Email was invented by Ray Tomlinson in 1972. A mailing list is based around software called a mailing list... en.kioskea.net/courrier-electronique/listes-diffusion.php3

Spreadsheets - The Excel Interface Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel document is called a file... en.kioskea.net/tableur/tabinterface.php3

1 2 3 Next