IF statement help

H

Holly

A B C
8 2 1

In column C I have the following
=IF(A2>7,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?
 
B

Bob Phillips

=IF(A2>7,1,IF(A2>=6,2,IF(A2>=3,3,IF(A2>=1,4,5))))-(B2>0)


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
A

Arvi Laanemets

Hi

=1+(A2>7)+(A2>=6)+(A2>=3)+(A2>=1)-(B2>0)
Another one
=MATCH(A2,{9999;7;5.9;2.9;0.9;-9999},-1)-(B2>0)
 
Top