Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Increase a cell by 1.3% | New Users to Excel | |||
How can I increase value in one cell as value in other decreases? | New Users to Excel | |||
Number in cell increase with increase in font size. | Excel Discussion (Misc queries) | |||
HOW DO COPY A CELL BUT INCREASE ITS REFERENCE BY TWO CELL POSITIO. | Excel Discussion (Misc queries) | |||
increase cell value | Excel Discussion (Misc queries) |