Hi
Try
=IF(A1=1,0,IF A1=3,3,IF(AND(A11,A1<3),2.5*(3-A1),""))

Regards

Roger Govier


wrote:
Hey,

Who can help me with a formule to solve this problem

The outcome of a som is for example "1" in cel A1, then I want that in
cel a2 it says "0", is the outcome in A1 "3", then I want that in cel
a2 it says "3", but if the outcome in a1 is between "1" and "3", than I
want that in A2 it says (2,5 x (3-A1).

Sorry for my bad englisch.