Lotus to Excel formula conversion p

hardman34, on Thursday April 17, 2008 12:32:17 PM

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 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#AND3B7>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 hardman34 Report this message to moderators Go to last message

1This message seems useful, vote!
Ce message ne vous semble pas utile, votez !
Report this message to moderators

spiderind, on Thursday April 17, 2008 02:22:55 PM

Hai

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 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/nests...

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.

Reply to spiderind

Ask your question Reply

Results for

Convert P2V on Linux Hello, Greetings, what is the best way to convert Physical to Virtual on Linux? In windows its easy .. (with vmconverter) but on Linux which is the best way, using partimage or ghost? Thank you very much! en.kioskea.net/forum/affich-1656-convert-p2v-on-linux

Need to convert pdf files Hi, I would like to know in whick format it is possible to convert Pdf files.. The actual adobe reader i am using enables me to just convert it in Text Format. Any alternatives?? Adv thanks :) Naomie ... en.kioskea.net/forum/affich-20732-need-to-convert-pdf-files

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

1 2 3 Next

Results for

Converting your PDF file into an ImageConverting your PDF file into an Image Universal Document Converter PDF2IMAGE PDF TO IMAGE CONVERTER You could have encountered difficulties to modify PDF docs in the past. Nowadays this is no more trouble as there are several PDF... en.kioskea.net/faq/sujet-187-converting-your-pdf-file-into-an-image

What is PCI ExpressWhat is PCI Express? Intro How does it work The different PCI buses Intro PCI Express, also named as PCI-E or PCIe (formerly 3GIO, 3rd Generation Input / Output) is the ultimate evolution of conventional PCI bus. Unlike PCI which is... en.kioskea.net/faq/sujet-776-what-is-pci-express

Video ConversionVideo Conversion Any Video Converter Total Video Converter Prism Video Converter With today’s technology, it is now possible to get various video formats. However, these files could each require a different audio player to be able... en.kioskea.net/faq/sujet-189-video-conversion

1 2 3 Next

Results for

Excel Function (Vlookup)Hello, I need help with the vlookup functions in excel. Let's say I have two tabs, the second tab is a pivot table based on the first tab. I want to build a vlookup function (probably need two in the same formula) to pick up a field in a... en.kioskea.net/forum/affich-7698-excel-function-vlookup

PDF to Word (editable)Hello, This is doing my nut in, and I’m not even convinced that editable is a real word, but hey. I've done this before successfully, but for the life of me i can't remember how. I want to convert PDF files to word documents that can be... en.kioskea.net/forum/affich-15613-pdf-to-word-editable

Firmnual Help If cell is blank go to next ceHello, 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

1 2 3 Next

Results for

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 11view11view is a slide viewer and a converter of pictures with several special functionality. The program notably allows to view, to print and to convert pictures with the best possible qualities.Special functions include options of outline in large... en.kioskea.net/telecharger/telecharger-487-11view

Download FxFotoFXFOTO is an administrator of pictures par excellence. Organize your photos automatically by acquisition. The program allows you to sail across the different files and to locate your photos faster for a quick visualization. Edit your photos to... en.kioskea.net/telecharger/telecharger-510-fxfoto

1 2 3 Next

Results for

Processes - grpconv - grpconv.exe grpconv.exe (grpconv stands for Windows Program Group Converter) is a Windows NT/2000/XP generic process used for converting program groups from older versions of Windows. The process grpconv is not in any way a virus, a worm, a Trojan horse,... en.kioskea.net/processus/grpconv-exe.php3

Cables and connectors - DVI connector DVI (Digital Video Interface) connectors, found on some graphics cards, are used for sending video signals digitally to screens with a suitable interface. They bypass the needless and potentially quality-reducing digital-analog conversion process. ... en.kioskea.net/elec/connecteur-prise-dvi.php3

Attacks - False HTPP data Most web application attacks involving soliciting a website with manually entered data to generate an unexpected context. The HTTP protocol, a communication protocol on the web, makes it possible to convey parameters in the form of requests; it can... en.kioskea.net/attaques/falsification-donnees.php3

1 2 3 Next