If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
nested if
I posted eariler and no answer. How do I nest an IF function that will read 3 different scenarios or results? Ex. If a cell in column A contains P, then give me the charge code xxxx-xxx in cell a5 in col K. I have three situations in this case. If you need more info, please read my earlier posting thta reads If in three steps. Thanks a lot for your help
|
#2
|
|||
|
|||
nested if
Nested if is the same as a non nested if, in that you test a condition,
if true do one action, if false do another - for nested if statements, the false is another if statement so =if(test1=true,1,if(test2=true,2,if(test3=true,3," no conditions are true"))) would test three conditions and return the result of whichever one is true first OR display no conditions are true if they all fail obviously replace test1=true etc with the actual test you want to carry out. Ash wrote: I posted eariler and no answer. How do I nest an IF function that will read 3 different scenarios or results? Ex. If a cell in column A contains P, then give me the charge code xxxx-xxx in cell a5 in col K. I have three situations in this case. If you need more info, please read my earlier posting thta reads If in three steps. Thanks a lot for your help -- Ash |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access should have design view for nested queries | JustAnotherITGuy | Running & Setting Up Queries | 4 | May 2nd, 2006 11:50 AM |
reference to nested tables | k2sarah | Tables | 1 | October 26th, 2005 04:23 AM |
Nested IF statements | John Simons | Worksheet Functions | 14 | February 16th, 2005 06:17 AM |
passing data from a Form to a nested Form at deep 3 | Tran | Using Forms | 2 | December 23rd, 2004 05:02 PM |
nested formula help needed | Worksheet Functions | 0 | October 14th, 2003 04:17 PM |