A B C
8 2 1
In column C I have the following
=IF(A2gt;7,1,IF(A2gt;=6,2,IF(A2gt;=3,3,IF(A2gt;=1,4,5))))
which is working for me however I would like this formula to also perform
the following.
If cell B2 gt; 0 i want it to subtract 1 from the result
(the actual number in C should be a zero)
Is this possible?
Try:
=IF(A2gt;7,1,IF(A2gt;=6,2,IF(A2gt;=3,3,IF(A2gt;=1,4,5))))-IF(B2gt;0,1,0)
HTH,
Ryan
quot;Hollyquot; wrote:
gt; A B C
gt; 8 2 1
gt;
gt; In column C I have the following
gt; =IF(A2gt;7,1,IF(A2gt;=6,2,IF(A2gt;=3,3,IF(A2gt;=1,4,5))))
gt; which is working for me however I would like this formula to also perform
gt; the following.
gt; If cell B2 gt; 0 i want it to subtract 1 from the result
gt; (the actual number in C should be a zero)
gt;
gt; Is this possible?
=IF(A2gt;7,1,IF(A2gt;=6,2,IF(A2gt;=3,3,IF(A2gt;=1,4,5))))-(B2gt;0)--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;Hollyquot; gt; wrote in message
...
gt; A B C
gt; 8 2 1
gt;
gt; In column C I have the following
gt; =IF(A2gt;7,1,IF(A2gt;=6,2,IF(A2gt;=3,3,IF(A2gt;=1,4,5))))
gt; which is working for me however I would like this formula to also perform
gt; the following.
gt; If cell B2 gt; 0 i want it to subtract 1 from the result
gt; (the actual number in C should be a zero)
gt;
gt; Is this possible?
Hi
=1 (A2gt;7) (A2gt;=6) (A2gt;=3) (A2gt;=1)-(B2gt;0)
Another one
=MATCH(A2,{9999;7;5.9;2.9;0.9;-9999},-1)-(B2gt;0)--
Arvi Laanemets
( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
quot;Hollyquot; gt; wrote in message
...
gt; A B C
gt; 8 2 1
gt;
gt; In column C I have the following
gt; =IF(A2gt;7,1,IF(A2gt;=6,2,IF(A2gt;=3,3,IF(A2gt;=1,4,5))))
gt; which is working for me however I would like this formula to also perform
gt; the following.
gt; If cell B2 gt; 0 i want it to subtract 1 from the result
gt; (the actual number in C should be a zero)
gt;
gt; Is this possible?
留言列表
