Sum greater or lower.

[RedRay56]

The scenario is I have 4 cells, F2, G2, H2, and I2. F2 has a number in it. I put a number in G2 and I need the difference of the two to go in either H2 or I2. If the difference is higher than F2 then the difference would go to H2. If the difference is lower than F2 then the difference would go to I2. What formulas would I put into H2 and I2?

[The_Snook]

Hi RedRay56,

Welcome to the forum! Try this:

In cell H2: =IF((G2-F2)>F2,(G2-F2),"")
In cell I2: =IF((G2-F2)<F2,(G2-F2),"")

What would you like to happen if the difference is the same?

Hope this helps.

Snook

[KOKOSEK]

	f	g	h	i
2	10	15	0	5
3	10	21	11	0

	f	g	h	i
2	10	15	=((g2-f2)>f2)*(g2-f2)	=((g2-f2)<f2)*(g2-f2)

[davsth]

You have also not defined the difference

eg g2=10, f2=5 difference 5

g2=5 f2=10 difference is 5 or -5?

does the solution do what you expect? it might need changine to abs (g2-f2)?

[RedRay56]

The result I care for would not show the negative but show the number. If it was "-5" then it would show as "5" in either cell. I'm not great with Excel. I attached a sample of the spread sheet I'm using.

[JeteMc]

It may help if you update the sample to show some hypothetical numbers that might appear in columns F and G and the corresponding values you would expect to see in columns H and I (manually calculated) so that we have something against which to compare the output of our proposed formulas/code.
Let us know if you have any questions.