IF Formula
=--(C1<"No")
"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
|