View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Trying to work out the difference in 2 cells.

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