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