Excel return value or run calculation if criteria is not met. Formula needed

Question

This is a fairly simply formula that I need syntax for. I do not know the syntax that Excel will accept.

Formula: I want to return a value of "0" if the target cell has a value of "2" or less. If the value is greater than "2" I want to multiply by "25".

I tried the below formula but my syntax is all wrong and am not sure where to look for correct syntax:

=IF(B2<2,0),(B2>2, B2*25)

Thank you for any help.

Answer 1

First, note the proper syntax for the IF() function:

IF(logical_test, value_if_true, [value_if_false])

The logical_test is B2 <= 2.
The value_if_true_ is 0.
The value_if_false (i.e., if B2 is > 2) is B2 * 25.

So the formula is =IF(B2<=2, 0, B2*25).

For example (data starting in B2, formula in C2):

        [B]     [C]
[2]     0       0
[3]     1       0
[4]     1.9     0
[5]     2       0
[6]     2.1     52.5
7       3       75
8       4       100

---

Follow-up from comments:

How would I set this formula so the value couldn't go over a certain number... ie I don't want it to return values over 100 and instead set the value to 100 if it would be higher.

Now you want another IF() function as to evaluate what you do if B2 > 2:

=IF(B2<=2, 0, IF(B2*25>100, 100, B2*25))

Answer 2

if(b2<2,0,b2*25) <- should work