question

[envandermolen]

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.

 

[moondark]

Code
-------------------
=IF(OR(A1="";A1>3);"";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 tha
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)


Simo

 

[Roger Govier]

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

Regards

Roger Govier