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.

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.

Code:
--------------------
=IF(OR(A1="";A13);"";IF(A1=1;"0";IF(A1=3;3;2.5*(3-A1))))
--------------------

first if statement clears cell A2 if value of A1 is empty or more than
3
second if returns 1 if A1 = 1
third if returns 3 if A1 = 3
in any other case it returns 2.5 * (3-A1)

:)
Simon


--
moondark
------------------------------------------------------------------------
moondark's Profile: http://www.excelforum.com/member.php...o&userid=27390
View this thread: http://www.excelforum.com/showthread...hreadid=470160