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

Similar Threads

Entereing an age and if statement in the same cell 1
Returning date instead of 'not null' 4
Adding cells but leaving blank if not populated 1
Zero and Null Sum Function 2
If, then statement with the condition a blank cell 10
How do I put a blank value in a cell not using "" in a formula 2
Diplaying results of a formula instead of the formula itself 1
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0

Top