dispatchergirl911
New Member
- Joined
- Aug 9, 2018
- Messages
- 4
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.
=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.