ExcelBanter - IF Logical Function & Blank Cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF Logical Function & Blank Cells (https://www.excelbanter.com/excel-worksheet-functions/137212-if-logical-function-blank-cells.html)

Jim

IF Logical Function & Blank Cells

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.

JE McGimpsey

IF Logical Function & Blank Cells

One way:

B1: =IF(ISNUMBER(A1),A1-<a math calculation,"")

In article ,
Jim wrote:

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.

All times are GMT +1. The time now is 08:18 AM.