Empty Cell ( blank Cell )

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to write formula or write in the formula " if cell is left blank or
empty" skip and carry with the rest of the formula
 
Would you give a little more detail? I am not sure what you want to do.
 
Maybe you're looking for something like this........

=IF(A1=B1,"",A1+B1)

Which says in Excel formula language, "if cell A1 is equal to cell B1, then
leave the cell where this formula is located blank, otherwise, put in it the
sum of A1 and B1.........

or maybe,
=IF(A1="",B1*2, B1*3)

Which says, if Cell A1 is empty, then put in the cell where this formula is
the product of B1 times 2, otherwise put B1 times 3...

The two quotation marks with no space between them represent the "null"
condition or for display purposes, a blank or empty cell...........

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

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

Excel formula, sum the value cell and if empty cell left blank 0
conditional formatting update issue 5
Hide columns based on row values 2
SUMIF with criteria "<>" & "=" 4
create blank/empty cell - don't want a zero to be plotted in chart 6
Return blank cell if data cell is blank 4
Comparison of columns using Conditional Formatting 3
HELP!!!!!!!!! 2

Back
Top