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.