Try:
=IF(A27,1,IF(A2=6,2,IF(A2=3,3,IF(A2=1,4,5))))-IF(B20,1,0)

HTH,
Ryan

"Holly" wrote:

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?