If, else function

[Stephanie]

I am trying to perform 2 if/and functions in the same
cell. I have a spread sheet that contains a column for
note type and status. If the note type = term and the
status = committed, return the value in cell B65 or if
the note type = term and the status = negotiations then
return the value in cell B69. I can get each section of
this to work by itself, but I can't combine the two.

=IF(AND(C6="TERM",D6="COMMITTED"),$B$65,"N/A")

ELSE

=IF(AND(C6="TERM",D6="NEGOTIATIONS"),$B$69,"N/A")

ELSE

"N/A"

 

[Dan E]

One way

=IF(AND(C6="TERM",D6="COMMITTED"),$B$65,IF(AND(C6="TERM",D6="NEGOTIATIONS"),$B$69,"N/A"))

Dan E