If, else function

  • Thread starter Thread starter Stephanie
  • Start date Start date
S

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"
 
One way

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

Dan E
 
Back
Top