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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Tony Houston" <Tony wrote in message
...
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