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?

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?

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


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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?

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?