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, BS Degree in Engineering.
Category: General
Satisfied Customers: 9666
Experience:  Math, science and 25 years experience in computer programming
53785
Type Your Question Here...
John D is online now
A new question is answered every 9 seconds

I need a IF function in excell to state that D18 is over

Resolved Question:

I need a IF function in excell to state that D18 is over 500, then insert 0 if the number in cell d18 is under 500 then insert 5% of the number in cell d18 the number in d18 is 1938.67
Submitted: 6 years ago.
Category: General
Expert:  John D replied 6 years ago.
Hi,

=IF(D18>500,0,0.05*D18)

Hope this is ok Please feel free to reply if you need further clarification or click Accept if this answers your question fully.
John D and 21 other General Specialists are ready to help you