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.
Here's a quick sample file with a little quick trick :)...add the ISBLANK function.
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
- Thank you. It worked but Riny_van_Eekelen solution is easier to implement. Thank you very much. I really appreciate it.
