Hi

=1+(A27)+(A2=6)+(A2=3)+(A2=1)-(B20)
Another one
=MATCH(A2,{9999;7;5.9;2.9;0.9;-9999},-1)-(B20)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Holly" wrote in message
...
A B C
8 2 1

In column C I have the following
=IF(A27,1,IF(A2=6,2,IF(A2=3,3,IF(A2=1,4,5))))
which is working for me however I would like this formula to also perform
the following.
If cell B2 0 i want it to subtract 1 from the result
(the actual number in C should be a zero)

Is this possible?