if statements

Tony Houston · Feb 7, 2005

I need to be able to use the if function based on the cell being empty/blank.
ie if(a1=blank,b1,0)

how do i use blank cell in the formula.
Thanks

Max · Feb 7, 2005

Try in say, C1: =IF(ISBLANK(A1),B1,0)