Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Q: Nested if
Hello,
Is it possible to create a nested if statment in excel? Thanks, Jim. |
#2
|
|||
|
|||
I found the answer of this, it is like if(a1=b1,1,if(a2=b2,2,0))
"JIM.H." wrote: Hello, Is it possible to create a nested if statment in excel? Thanks, Jim. |
#3
|
|||
|
|||
You can create a nested IF formula. For example:
=IF(A25,0,IF(B210,0,C2)) or =IF(A25,IF(B210,0,C2),0) JIM.H. wrote: Hello, Is it possible to create a nested if statment in excel? Thanks, Jim. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) | |||
Problem with data using IF and Nested IF statements possibly??? | Excel Discussion (Misc queries) | |||
Combining SUM Function with Nested If Statement | Excel Discussion (Misc queries) | |||
Need HELP with NESTED IF | Excel Discussion (Misc queries) |