Hi,

Hope somebody can help.

I am trying to work out the difference between 2 cells EG: 1 cell J51 has a
total amount of £900.00 and cell J52 has total amout of £1500.00. I want to
try and work out and show in cell J53 the total if J51 is greater than J52 or
if J51 is Less then J52 I have tried various ways but don't seem to get the
answer I want.

I hope I have made myself clear.
--
scary says thanks you very much

Hi,


Isn't it as simple as

=J51-J52

Mike

"scary" wrote:

Hi,

Hope somebody can help.

I am trying to work out the difference between 2 cells EG: 1 cell J51 has a
total amount of £900.00 and cell J52 has total amout of £1500.00. I want to
try and work out and show in cell J53 the total if J51 is greater than J52 or
if J51 is Less then J52 I have tried various ways but don't seem to get the
answer I want.

I hope I have made myself clear.
--
scary says thanks you very much

Or maybe =IF(J51=J52,"Peter and Paul are equal",IF(J51J2, "Peter has
more","Paul has more"))
OR =J1J2 will return either TRUE or FALSE
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"scary" wrote in message
...
Hi,

Hope somebody can help.

I am trying to work out the difference between 2 cells EG: 1 cell J51 has
a
total amount of £900.00 and cell J52 has total amout of £1500.00. I want
to
try and work out and show in cell J53 the total if J51 is greater than J52
or
if J51 is Less then J52 I have tried various ways but don't seem to get
the
answer I want.

I hope I have made myself clear.
--
scary says thanks you very much

Perhaps you want:

=ABS(J52-J51)

which will give you the (positive) difference between the two, but
will not tell you which is the larger of the two.

Hope this helps.

Pete

On Jul 6, 11:59*am, scary wrote:
Hi,

Hope somebody can help.

I am trying to work out the difference between 2 cells EG: 1 cell J51 has a
total amount of £900.00 and cell J52 has total amout of £1500.00. I want to
try and work out and show in cell J53 the total if J51 is greater than J52 or
if J51 is Less then J52 I have tried various ways but don't seem to get the
answer I want.

I hope I have made myself clear.
--
scary says thanks you very much

Hi,

This helped me thank you.
I tweeked it abit but kept the main structure
--
scary says thanks you very much


"Bernard Liengme" wrote:

Or maybe =IF(J51=J52,"Peter and Paul are equal",IF(J51J2, "Peter has
more","Paul has more"))
OR =J1J2 will return either TRUE or FALSE
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"scary" wrote in message
...
Hi,

Hope somebody can help.

I am trying to work out the difference between 2 cells EG: 1 cell J51 has
a
total amount of £900.00 and cell J52 has total amout of £1500.00. I want
to
try and work out and show in cell J53 the total if J51 is greater than J52
or
if J51 is Less then J52 I have tried various ways but don't seem to get
the
answer I want.

I hope I have made myself clear.
--
scary says thanks you very much