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
53785
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

Hi,

 

Ok this formula in C4 should do it

 

=IF(B4>24999,0.05,0.02)

 

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