Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formula
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 |