I want to create an IF statement that leaves a cell blank if....

K

KK

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?
 
J

Jacob Skaria

=IF(A1+0=0,"",A1)
OR
=IF(A1+0=0,"","do whatever")

If this post helps click Yes
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top