Conditional formula Column N currently has the formula =IF(I2=0,0,(SUM(I2-H2)))

Question

Conditional formula   

Column N currently has the formula =IF(I2=0,0,(SUM(I2-H2))) because if any cell in column I is imported with a blank value, I want the value in column N of that corresponding row to reflect $0.00 as the value. See first illustration.

What I need to add in addition is this formula is the function that if "$0.00" is entered any cell in column I, the result will calculate the numerical difference.   See second illustration.

So if cell I is blank in any given row, the result in N should be $0.00. If $0.00 is entered in cell I, cell N should result with the difference between value in cell I less value in cell H.

Explanation / Answer

#%&%#

=IF(ISBLANK(I2),0,IF(ISNUMBER(I2),I2-H2,"ERROR"))

T^his should work:

For I2 = "blank", you will get zero.

For any value in I2 not blank, you will get I2-H2, unless I2 has something that is not a number, in which case you get "ERROR"./,

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.