Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to include ranges of data in a nested EXCEL formula
I am attempting to create a formula which links the number of patient beds in
a given hospital to the number of square feet needed in the Dietetics department of that hospital. All the possible bed totals have been reduced to seven outcomes: (from 1-100 beds should generate 6,650 square feet of dietetics; 101-200 beds should generate 8,645; 201-300 should generate 10,640; 301-400 should generate 12,635; 401-500 should generate 14,630; 501-600 should generate 16,625 and 600-2000 should generate 18,620) The sum of all beds is captured in cell D61 and the following attempt was made to create the desired formula. It was unsuccessful. Wherein is my syntax error? =IF(D61=1:100,(6650),IF(D61=101:200,(8645),IF(D61= 201:300,(10640),IF(D61=301:400,(12635),IF(D61=401: 500,(14630),IF(D61=501:600,(16625),IF(D61=601:2000 ,(18620)))))))) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |