Forum Discussion
Solved
Blank value in Cell
Hi, I have a problem calculating. I have a column containing three types of values i.e. Yes, No, and a blank cell. I am creating two columns of Yes & No. In the cell, I write the formula (=if(a1="Yes...
For the Yes column enter:
=IF(ISBLANK(A1),"",--(A1="Yes"))
For the No column enter:
=IF(ISBLANK(A1),"",--(A1="No"))
And copy the formulae down.
For the Yes column enter:
=IF(ISBLANK(A1),"",--(A1="Yes"))
For the No column enter:
=IF(ISBLANK(A1),"",--(A1="No"))
And copy the formulae down.
- Thank you, Riny for the great solution. it worked though Mr. Nikolino's solution was also correct your's was easier. Thank you Sir, So nice of you.
