Search : in
By :

IF fnct

Last answer on Jul 3, 2009 10:08:29 am BST rm, on Jul 2, 2009 1:39:44 pm BST 
 Report this message to moderators

Hello,
How do I nest an IF function that is more than 8-deep, can i be given some techniques.

rubara

Configuration: Windows XP
Firefox 3.0.11

Best answers for « IF fnct » in :
[Myth] aMSN allows you to know if someone has blocked you on WLM Show aMSN allows you to know if someone has blocked you on Windows Live Messenger Myth Reality Explanations Myth aMSN software allows us to know who blocked us on Windows Live Messenger. Reality FALSE Explanations When it was launched,...
How do I know if a website is secure? Show How do I know if a website is secure? Determine if you are on a secured page or not. Some web sites use a secure connection between the web site and your browser. This may be important to you, for instance, if you want to pay...
[Linux] Check if your CD has been successfully burned Show [Linux] Check if your CD has been successfully burned Intro Notes Implementation Intro Under Linux there is a small utility that allows you directly to verify file integrity by comparison. It is call md5sum that calculates the...
[MSN Messenger] Determine if a contact has accepted you Show[MSN Messenger] Determine if a contact has accepted you If you want to know if someone has accepted you: Go to Tools / Options Privacy tab View the list of users See who has added you to thier contact list Click on View.
[Excel 2003] - IF Function using Dates & Text Show[Excel 2003] - IF Function using Dates & Text Issue Solution Note Issue I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell will read U16, but...
How to speed up a slow PC ShowHow to speed up a slow PC Problem 1: Not enough RAM How to know if your computer has enough RAM Problem 2: Temporary files have built up on your hard disk How to delete Temporary Files Problem 3: Your computer has been infected Problem 4:...
Download Visual Task Tips ShowThe display of thumbnails of open windows in the taskbar is a new feature that was introduced in Vista. Visual Task Tips is a small program that lets you do so in XP. If you want your XP look like Vista, then you need this software. For more...
Ask your question Reply

1

venkat1926, on Jul 3, 2009 12:50:09 am BST
   
Reply to venkat1926

2

mubashir aziz, on Jul 3, 2009 3:59:09 am BST

Yes sure you can see below solution from mine ..... you can use upto 36 IF's and 37 conditions ....

you can paste this code in B3 and in A3 write alphabet from A-Z and numeric from 0-9 and try to write some special char and see the result in B3 ..... There are many ways to get the same result but i especially made this formula to know how of nested IF's ........ 



B3=IF(OR(A3="a",A3="b",A3="c",A3="d",A3="e",A3="f",A3="g",A3="h"),IF(A3="a",1,IF(A3="b",2,IF(A3="c",3,IF(A3="d",4,IF(A3="e",5,IF(A3="f",6,IF(A3="g",7,8))))))),IF(OR(A3="i",A3="j",A3="k",A3="l",A3="m",A3="n",A3="o"),IF(A3="i",9,IF(A3="j",10,IF(A3="k",11,IF(A3="l",12,IF(A3="m",13,IF(A3="n",14,15)))))),IF(OR(A3="p",A3="q",A3="r",A3="s",A3="t",A3="u"),IF(A3="p",16,IF(A3="q",17,IF(A3="r",18,IF(A3="s",19,IF(A3="t",20,21))))),IF(OR(A3="v",A3="w",A3="x",A3="y",A3="z"),IF(A3="v",22,IF(A3="w",23,IF(A3="x",24,IF(A3="y",25,26)))),IF(OR(A3=1,A3=2,A3=3,A3=4),IF(A3=1,"N1",IF(A3=2,"N2",IF(A3=3,"N3","N4"))),IF(OR(A3=5,A3=6,A3=7),IF(A3=5,"N5",IF(A3=6,"N6","N7")),IF(OR(A3=8,A3=9),IF(A3=8,"N8","N9"),IF(A3=0,"Zero","Non of Single Alphabet / Single Numerics"))))))))





Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran, Pakistan

   
Reply to mubashir aziz

3

 venkat1926, on Jul 3, 2009 10:08:29 am BST

Thank you very much

   
Reply to venkat1926
Ask your question Reply
They need your help