Replace whatever is between the last comma and the last bracket in the first formula with the second formula,
IF(OR(B10="ABC",B10=DEF"),I10-H10,IF(B10="GHI",G10,""))
or
IF(B10="GHI",G10,IF(OR(B10="ABC",B10=DEF"),I10-H10,0))
Replace whatever is between the last comma and the last bracket in the first formula with the second formula,
IF(OR(B10="ABC",B10=DEF"),I10-H10,IF(B10="GHI",G10,""))
or
IF(B10="GHI",G10,IF(OR(B10="ABC",B10=DEF"),I10-H10,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks