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

  • Thread starter Thread starter Frustrated
  • Start date Start date
F

Frustrated

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")
 
Frustrated said:
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")
Click to expand...


=INT(P2/3)
 
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.
 
Back
Top