How do you create an Excel formula that will automatically discount a number by 5% if it is over 100?

by on June 7, 2013

Q: hey when using exel how do you create a formula that will take 5% off automatically if the number is greater then 100


One Response to “How do you create an Excel formula that will automatically discount a number by 5% if it is over 100?”
  1.  

    The function you will want to use is the IF function and you will want to do something like this in column B with your data being in column A

    =IF(A1>=100, A1*0.95, A1)