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