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: 16429
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

Hi I need a formulae for microsoft professional excel 2010.

This answer was rated:

I need a formulae for microsoft professional excel 2010. Cell B19 shows a dollar amount of $48.50 but if cell B35 is selected with 'Y' then the amount in cell b19 needs to change to $45.50...if cell b35 is left blank then cell b19 remains at $48.50.


Jason :

Hello and thank you for your question today. My name isXXXXX look forward to helping you today.

Here is the formula that you need to place in B19:

Jason :

I look forward to your next message or your rating below.

Thank you again,
- Jason


Jason Jones and other Microsoft Office Specialists are ready to help you

Thank you.