New Column Ignoring Blanks

[CPRGroup1]

Hi there,

I would like to create a New Column using a calculation but skipping over in the rows that contain blanks.

ie.

New Column = Column 2 - Column 1

In Column 2 there are blanks.

I'd like the equation to not apply to the rows with blanks in coloum 2.

Thank you

[tarunsingla]

NewColumn = IF(NOT(ISBLANK(column2)), column2 - column1)

[HotChilli]

Use an IF statement with ISBLANK