IF Formula Question

[dispatchergirl911]

I am trying to put in a formula that will remain blank if the target cell is blank, show 1 if the target cell is "Yes" and show 0 if the target cell is "No". Here is the current formula:

=IF([@[Primary covered]]=" "," ",IF([@[Primary covered]]="Yes","1","0"))

[@[Primary covered]] is E2 in the table. It is returning the 1 for "Yes" and 0 for "No", but is still putting 0 when the target cell is blank.

 

[duggie33]

Try =IF([@[Primary covered]]="","",IF([@[Primary covered]]="Yes","1","0"))

I removed the space between the "". In Excel "" represents and empty cell.

Hopefully it works,

Doug

 

[dispatchergirl911]

That worked! Thank you for your help

 

[duggie33]

You are welcome.