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 James K. Your Own Question
James K.
James K., Consultant
Category: Microsoft Office
Satisfied Customers: 6598
Experience:  Technical Director of IT Company
Type Your Microsoft Office Question Here...
James K. is online now
A new question is answered every 9 seconds

I have two columns. Budget Amts / Actuals. What formula do

This answer was rated:

I have two columns. Budget Amts / Actuals. What formula do I put in another column to show the $ amount of difference showing whether it is negative or positive?


My name is James

Welcome to Just Answer

Can I remote onto your Machine and have a look at your problem

This Means i can look at the sheet and help you

Remote means i can see your issue and fix this for you

Its fully Secure and Built into the Just Answer System and you can see what i am doing at all times

If you wish i can send you the details to connect

Cheers James
Customer: replied 3 years ago.


my excel spread sheet is on my office computer. I have one column where budget amounts are entered. In the column to the right is another column where I am entering in actual monthly expenses. I want another column to the right that is entitled "diff" showing whether the diff is, showing if I met budget or I am over budget. Is that done with (-) or (+) by the amount?


It would be


Where A2 is the Budget Amount and B2 is actual Amount

The diff formula would be =A2-B2


£100.00 £200.00 -£100.00

Would show like the above

But the first columns need to be formated as currency

Right Click >format >Currency

I have made one for you , you can use that is done

CLICK HERE and the green download button

Let me know any problems

Cheers James

Thanks James

Now Please Rate My Answer with the Smiley Faces and Submit

Come back if you have any more issues

Cheers James
James K. and 4 other Microsoft Office Specialists are ready to help you

Related Microsoft Office Questions