Multiply cells only if a cell is nonblank

[cableghost]

In the attached spreadsheet, I wish to run the below calculation in DATA J2. However, I only want (I2+H2)/2 to occur if H2 is nonblank. If H2 is blank, then only calculate (=I2-E2).

Please Login or Register  to view this content.

Basically, I want to...

Calculate ((I2+H2)/2)-E2 if H2 is nonblank, otherwise calculate =I2-E2

[cubangt]

Try this

=IF(ISBLANK(H2),I2-E2,((I2+H2)/2)-E2)

Just place that formula in your J2 and copy down

[cableghost]

=IF(ISBLANK(H2),I2-E2,((I2+H2)/2)-E2)

This appears to work... thanks!

[cableghost]

I now do recognize its throwing an error... 'Inconsistent Calculated Column Formula', but the calculation seems to be correct

[cubangt]

In the error box that shows up to the side of the cell, select the 2nd option "Restore to calculated column formula" and reapply down the rest of the cells

[cableghost]

In the error box that shows up to the side of the cell, select the 2nd option "Restore to calculated column formula" and reapply down the rest of the cells

Tried that... this new formula is wiped out and the old calculation is returned.

Edit: Got it figured out.