Backward subtraction forumla!

I am try to develop a forumla that calculates (subtraction) backwards example:

8 subtraction by (unknow value) resulting in 4 = 4

as 8-4=4

4 is the aswaer

So you want to find x in the following:

8 - x = 4

Or, using cells A1 and A2:

A1 - x = A2

So in a different cell, simply use:

=A1 - A2

HTH

Jason

that's great but not so simply....

what happens when I have

8 - x = 1

aswner should be "9" but using your formula give me "7"

I tryed to create a forumla which surprisely does not work:

A1=8
A2=4

so

=IF(4-A1=A2,"4","")

Well, last I checked,

8 - x = 1

x = 7

8 - 7 = 1

My very simple formula will work for the scenario you are describing.

Jason

I got it to work now but there is two answers to the question:

8-x=1 answer 97

8-9=1
8-7=1

Sorry, but 8 - 9 does not equal 1.

8 - 7 = 1
8 - 9 = -1

What do you mean by "answer 97"?

Maybe you're just not fully explaining what you need.