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

this formula need syntax for. not know syntax excel accept.

formula: want return value of "0" if target cell has value of "2" or less. if value greater "2" want multiply "25".

i tried below formula syntax wrong , not sure correct syntax:

=if(b2<2,0),(b2>2, b2*25)

thank help.

first, note proper syntax if() function:

if(logical_test, value_if_true, [value_if_false])

the logical_test b2 <= 2.
value_if_true_ 0.
value_if_false (i.e., if b2 > 2) b2 * 25.

so formula =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 comments:

how set formula value couldn't go on number... ie don't want return values on 100 , instead set value 100 if higher.

now want if() function evaluate if b2 > 2:

=if(b2<=2, 0, if(b2*25>100, 100, b2*25))