How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Jason Jones Your Own Question
Jason Jones
Jason Jones, Computer Technician
Category: Microsoft Office
Satisfied Customers: 16660
Experience:  Over 10 years work experience.
Type Your Microsoft Office Question Here...
Jason Jones is online now
A new question is answered every 9 seconds

I am trying to subtract one cell R35 from another R29. Both

This answer was rated:

I am trying to subtract one cell R35 from another R29. Both have numbers in but the answer I get is a zero - with the zero displayed as "£ -" - because I am using the accounting format. The value in R29 is £192 and itself is the sum of two other cells so its formula is q29 - p 29. When I try to check the error in R29 by trying to find its absolute value using =abs(R29), excel again returns zero "£-". Any idea what is wrong? If I paste the value in r29 into another cell, I can do the sum properly, but the whole point of excel is to be able to do multiple functions so I am keen to get to the bottom of the error.
Many thanks in advance, Hamish
Hello and thank you for your question today. My name is Jason. I look forward to helping you today.

May I take a look at a sample of what you are dealing with?

Please, be forewarned that the site is not secure:
- Click the following link:
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"

Customer: replied 4 years ago.

File ID: 194518


Customer: replied 4 years ago.

File ID: 194518

Please, explain what I am looking at.

You created multiple circular references here.

Which cells are you having problems with?

Thank you.
Customer: replied 4 years ago.

Please can you explain why d8 is returning a zero value?


I sure can.

You had three circular references for the totals.

Here is the fixed sheet:

You were summing B6:B8 and placing the value in B8. You cannot do that. I changed the sum to B6:B7
Jason Jones and 2 other Microsoft Office Specialists are ready to help you