I need help when trying to figure out the the percentage for a certain cell. I need a formula that looks at a certain cell and if the number within that cell is more than 100 a discount is then given and the results displayed in a different cell can anyone help me.