IF Formula
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
|