ExcelBanter - Q: Nested if

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Q: Nested if (https://www.excelbanter.com/excel-discussion-misc-queries/2782-q-nested-if.html)

JIM.H.

Q: Nested if

Hello,
Is it possible to create a nested if statment in excel?
Thanks,
Jim.

JIM.H.

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.

Debra Dalgleish

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

All times are GMT +1. The time now is 08:00 PM.