I am sure this is easy for most of you, but I am struggling. I would like to put 2 IF Functions in one cell.
I started with this and it works fine:
=IF(A12="X",1,0)
I would just like to add that IF B12 has an X, then it would equal 1 as well. Either A12 or B12 will have an X, never both.
How can I add the second IF?
Thanks!
<colgroup><col style="mso-width-source:userset;mso-width-alt:1308;width:28pt" width="37"> <col style="mso-width-source:userset;mso-width-alt:1365;width:29pt" width="38"> <col style="width:48pt" span="7" width="64"> <col style="mso-width-source:userset;mso-width-alt:2673;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:3811;width:80pt" width="107"> </colgroup><tbody>
[TD="class: xl79, width: 37"]NO[/TD]
[TD="class: xl79, width: 38"]YES[/TD]
[TD="class: xl77, width: 448, colspan: 7"]INSPECTION[/TD]
[TD="class: xl77, width: 75"]POINT VALUE[/TD]
[TD="class: xl77, width: 107"]POINTS ACHIEVED[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl70"]X[/TD]
[TD="class: xl81, width: 448, colspan: 7"]All outside lighting 100% operational[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl69"]X[/TD]
[TD="class: xl72, width: 448, colspan: 7"]Parking lot and surrounding area of store free of debris[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl69"]X[/TD]
[TD="class: xl72, width: 448, colspan: 7"]Front entry swept or shoveled[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl69"]X[/TD]
[TD="class: xl72, width: 448, colspan: 7"]Landscaping in good appearance[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl69"]X[/TD]
[TD="class: xl72, width: 448, colspan: 7"]Music turned on in store and at correct volume[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]X[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl73, colspan: 7"]Windows cleaned, Escalator and Elevator clean and free of debris[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]0[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl69"]X[/TD]
[TD="class: xl73, colspan: 7"]Correct sale event signing displayed[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl69"]X[/TD]
[TD="class: xl73, colspan: 7"]All ceiling tiles free of water stains and in good condition[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl71"]X[/TD]
[TD="class: xl74, width: 448, colspan: 7"]Carpets cleaned and vacuumed [/TD]
[TD="class: xl68"]1[/TD]
[TD="class: xl68"]1
[/TD]
</tbody>
I started with this and it works fine:
=IF(A12="X",1,0)
I would just like to add that IF B12 has an X, then it would equal 1 as well. Either A12 or B12 will have an X, never both.
How can I add the second IF?
Thanks!
<colgroup><col style="mso-width-source:userset;mso-width-alt:1308;width:28pt" width="37"> <col style="mso-width-source:userset;mso-width-alt:1365;width:29pt" width="38"> <col style="width:48pt" span="7" width="64"> <col style="mso-width-source:userset;mso-width-alt:2673;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:3811;width:80pt" width="107"> </colgroup><tbody>
[TD="class: xl79, width: 37"]NO[/TD]
[TD="class: xl79, width: 38"]YES[/TD]
[TD="class: xl77, width: 448, colspan: 7"]INSPECTION[/TD]
[TD="class: xl77, width: 75"]POINT VALUE[/TD]
[TD="class: xl77, width: 107"]POINTS ACHIEVED[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl70"]X[/TD]
[TD="class: xl81, width: 448, colspan: 7"]All outside lighting 100% operational[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl69"]X[/TD]
[TD="class: xl72, width: 448, colspan: 7"]Parking lot and surrounding area of store free of debris[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl69"]X[/TD]
[TD="class: xl72, width: 448, colspan: 7"]Front entry swept or shoveled[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl69"]X[/TD]
[TD="class: xl72, width: 448, colspan: 7"]Landscaping in good appearance[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl69"]X[/TD]
[TD="class: xl72, width: 448, colspan: 7"]Music turned on in store and at correct volume[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]X[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl73, colspan: 7"]Windows cleaned, Escalator and Elevator clean and free of debris[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]0[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl69"]X[/TD]
[TD="class: xl73, colspan: 7"]Correct sale event signing displayed[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl69"]X[/TD]
[TD="class: xl73, colspan: 7"]All ceiling tiles free of water stains and in good condition[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl71"]X[/TD]
[TD="class: xl74, width: 448, colspan: 7"]Carpets cleaned and vacuumed [/TD]
[TD="class: xl68"]1[/TD]
[TD="class: xl68"]1
[/TD]
</tbody>