0

Can't seem to figure out this simple formula.

I have a value in a particular cell based upon a previous calculation. If that value is above 120 then I need to multiply the value over 120 by 25 and place the result into another cell. I tried an IF function but that seems to be focussed on words or type.

So what I am trying to do is provide a result for cell D10 with the following calculation:

If C10>120 then (C10-120)*25

Let's say for argument sake that the value in C10 is 135, then the result that needs to be posted to D10 is 375 i.e 15 * 25, because I am only interested in the value above 120. However, if it is equal to or below 120, then the value in D10 needs to be 0 (zero).

Is anyone able to help?

New contributor
logozuu is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
1

Have you tried the formula below?

=IF(C10>120,(C10-120)*25,0)

enter image description here

| improve this answer | |
  • Thanks so much, Emily. It looks like i had stupidly forgot the brackets around the second part of the equation. It worked a charm. – logozuu Jun 30 at 11:33
0

Another option:

=MAX(A1-120,0)*25

enter image description here

| improve this answer | |

Your Answer

logozuu is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.