Hi Folks I have a formula in cell c1 =if(a1>b1,1,0)
which is fine
The problem is when I fill the cells down to c10, the result is 0 because the other cells in the formula don't have any numbers yet. I want the cells to be blank,the formula I tried to use is
=isblank(if(a1>b1,1,0),"")
but doesn't work can anyone tell me what I am doing wrong
thank you
which is fine
The problem is when I fill the cells down to c10, the result is 0 because the other cells in the formula don't have any numbers yet. I want the cells to be blank,the formula I tried to use is
=isblank(if(a1>b1,1,0),"")
but doesn't work can anyone tell me what I am doing wrong
thank you