If you mean, looking "blank", then the usual way would be something like this
in say, B2: =IF(A2="","",yourformula)

B2 will appear "blank" (it'll contain a zero length null string: "")
if A2 is either blank or if A2 contains a zero length null string: ""

There's no formula which will return a real blank
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"KK" wrote:
I want to create an IF statement that leaves a cell blank if the value in
another cell is blank or zero. How would I craft this formula please?