IF Logical Function & Blank Cells

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

Guest

How do I state IF cell a1 is blank, then b1 +blank also or if cell a1 has any
positive or negative number, including 0, then b1= a1-a math calculation. I
am trying to apply math formulas to multiple columns of test data in which
some cells have no test data.
 
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

SUMIF with criteria "<>" & "=" 4
How to return a blank formula cell if the reference is blank? 2
Ms Excel Multiple Logical Test Function 0
Excel formula, sum the value cell and if empty cell left blank 0
when setting a cell to equal a blank cell it displays 0 2
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Remove punctuation mark, Split cells & average accross column 4
Return Blank from Cell Calculation 2

Back
Top