Why do you think it's safe to assume that?

"NPell" wrote:

On Feb 13, 9:31 am, Mike H wrote:
Maybe

=IF(OR(C1="Yes",C1="N/A",),1,IF(C1="No",0,""))

Miek



"d7" wrote:
I need an IF formula (or something)

Yes = 1, No = 0, N/A = 1. (Column A and B)
When i enter either yes, no or n/a (in column C) i want the corresponding
number to return in column D.

A B C D
Yes 1 Yes (Formula)
No 0
n/a 1- Hide quoted text -

- Show quoted text -

=IF(C1="No",0,"1")

Assuming no other entry except Yes, No or N/A will be entered.
It then will show a 0 for No, and a 1 for any other value.