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 John D Your Own Question
John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

I am trying to write an expression ex: =ifb4>249999,c4=.05(b4<249999,c4=.02)

This answer was rated:

I am trying to write an expression ex: =ifb4>249999,c4=.05(b4<249999,c4=.02) excel tells me no matter how I've entered it, it has an error. I am at hour 3 for just this problem. Help, please



Ok this formula in C4 should do it




Hope this is ok. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution


Customer: replied 5 years ago.
Have to plug it in first to be certain it works.

Sure, go ahead and plug it and let me know if there are any issues



John D and 3 other Microsoft Office Specialists are ready to help you