Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF functions beyond eight items?
small change for negatives Kostis
=CEILING(MAX(A12,0),5)/2 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "vezerid" wrote in message ups.com... Sherry, in your example, the value returned by each IF is half the upper limit. Since the upper limit of each interval increases by 5, and if this pattern continues, then you can replace your formula with: =CEILING(A12,5)/2 HTH Kostis Vezerides |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF functions beyond eight items?
I am trying to write a formula using the IF funciton. The formula itself is
fine. My problem is, though, I need more than just seven conditions. I actually need 12 The formula currently reads like this: =IF(A12<=0,0, IF(A12<=5, 2.5, IF(A12<=10,5, IF(A12<=15, 7.5, IF(A12<=20,10, IF(A12<=25, 12.5, IF(A12<=30, 15, IF(A12<=35, 17.5)))))))) As can be seen, this formula criteria goes in increments of 5. I need to be able to expland this formula to include amounts for <=40, <=45, <=50, <=55, <=60, which would mean I would need 5 more IF statements in that string. However, it will not let me go beyond eight of them. Does anyone have an idea of how I can get around this and make my formula work? Thanks! -- Sherry |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF functions beyond eight items?
Sherry,
in your example, the value returned by each IF is half the upper limit. Since the upper limit of each interval increases by 5, and if this pattern continues, then you can replace your formula with: =CEILING(A12,5)/2 HTH Kostis Vezerides |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF functions beyond eight items?
Hi Bob,
I guess I have been rusty too long. Actually nice idea for an assignment <wide evil grin. Kostis Bob Phillips wrote: small change for negatives Kostis =CEILING(MAX(A12,0),5)/2 -- HTH Bob Phillips |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested IF Statement Question | Excel Discussion (Misc queries) | |||
OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
Pareto's Law and ABCD ranking of items | Excel Discussion (Misc queries) | |||
Visible rows and functions that work | Excel Worksheet Functions | |||
nested if(and) functions | Excel Discussion (Misc queries) |