Excel Formula Help?

Question

I'm trying to obtain a formula that will accomplish two things:

1. Leave the cell blank if there is a computing error; and
2. Leave the cell blank if the computation results in the negative of another cell.

For the first condition, I came up with:
=IF(OR(ISERROR(A1-A2), ISERROR(A2-A1))," ",A1-A2)
This formula subtracts A2 from A1, and leaves the cell blank if an error would result from subtracting A2 from A1, or vice-versa.

For the second condition, I came up with:
=IF(OR(A1-A2=-A2, A2-A1=-A1)," ",A1-A2)
This formula subtracts A2 from A1, and leaves the cell blank if a value is missing for either A1 or A2.

Sometimes in my spreadsheet, I get the formula error. Other times, I get the negative of the other cell. I'm not sure why this happens; that's why I'd like to solve for both conditions in one formula.

I've tried many, many times to write a single formula that combines both conditions, with no luck. Any suggestions?

Answer 1

The second condition first : if either A1 or A2 are blank then blank otherwise A1-A2

your formula should look like that
=IF(OR(ISERROR(A1-A2), ISERROR(A2-A1)),"",IF(OR(A1="" , A2 =""),"",A1-A2))

Answer 2

Are the numbers to the main suitable of the / character continually one digit in length? if so, paste this formulation in D16 =SUMPRODUCT((N(suitable(A1:A1000, a million)=suitable(D15,a million)))*(B1:B1000)) in the adventure that your documents is going previous row 1000, substitute the loads to a pair form bigger than what you have. The above formulation assumes all your documents in column A starts with g/z.

Answer 3

What do you consider an error. if an error is the cell being less than 0 then this will do it.
=IF(OR((CA3-CC3>0),(CC3-CA3>0))," ",CA3-CC3)
=IF(OR((CA3-CC3=""),(CC3-CA3=""))," ",CA3-CC3)