Increase cell B by one for every 3 in cell A up to 50?
 

I have nested a IF formula but since i can only nest 7, i need another way to
get the same results but going to 50 in cell A. Can someone help? Here is
my current IF statement.
=IF(P2=3,IF(P2=6,IF(P2=9,IF(P2=12,IF(P2=15,IF (P2=18,IF(P2=21,IF(P2=24,8,"7"),"6"),"5"),"4"), "3"),"2"),"1"),"0")

Increase cell B by one for every 3 in cell A up to 50?
 

Frustrated wrote:
I have nested a IF formula but since i can only nest 7, i need another way to
get the same results but going to 50 in cell A. Can someone help? Here is
my current IF statement.
=IF(P2=3,IF(P2=6,IF(P2=9,IF(P2=12,IF(P2=15,IF (P2=18,IF(P2=21,IF(P2=24,8,"7"),"6"),"5"),"4"), "3"),"2"),"1"),"0")


=INT(P2/3)

Increase cell B by one for every 3 in cell A up to 50?
 

Will this work for your conditionss

=FLOOR(P2,3)/3

If this post helps click Yes
---------------
Jacob Skaria


"Frustrated" wrote:

I have nested a IF formula but since i can only nest 7, i need another way to
get the same results but going to 50 in cell A. Can someone help? Here is
my current IF statement.
=IF(P2=3,IF(P2=6,IF(P2=9,IF(P2=12,IF(P2=15,IF (P2=18,IF(P2=21,IF(P2=24,8,"7"),"6"),"5"),"4"), "3"),"2"),"1"),"0")

Increase cell B by one for every 3 in cell A up to 50?
 

Other contributors have given suggestions, but did you really intend the 8
to be a number and the 7, 6, 5, 4, ..., 0 each to be a text string?
If this was not your intention, be careful about scateering quote marks
around your formula.
--
David Biddulph

"Frustrated" wrote in message
...
I have nested a IF formula but since i can only nest 7, i need another way
to
get the same results but going to 50 in cell A. Can someone help? Here
is
my current IF statement.
=IF(P2=3,IF(P2=6,IF(P2=9,IF(P2=12,IF(P2=15,IF (P2=18,IF(P2=21,IF(P2=24,8,"7"),"6"),"5"),"4"), "3"),"2"),"1"),"0")