Excel 2007 : Multiple IF statements in one cell

Okay, I need to do an apartment building calculation spreadsheet.

The demand factor percentage changes depending on how many dwelling units are in the building. In cell A1, one would input how many dwelling units. Cell B1 would display the demand factor. The information is below. I'm stuck as to how to actually get all this information in one freaking cell.

NUMBER OF
DWELLING	 DEMAND
UNITS		 FACTOR (%)

IF   (3-5), THEN (45)
IF   (6-7), THEN (44)
IF  (8-10), THEN (43)
IF    (11), THEN (42)
IF (12-13), THEN (41)
IF (14-15), THEN (40)
IF (16-17), THEN (39)
IF (18-20), THEN (38)
IF    (21), THEN (37)
IF (22-23), THEN (36)
IF (24-25), THEN (35)
IF (26-27), THEN (34)
IF (28-30), THEN (33)
IF    (31), THEN (32)
IF (32-33), THEN (31)
IF (34-36), THEN (30)
IF (37-38), THEN (29)
IF (39-42), THEN (28)
IF (43-45), THEN (27)
IF (46-50), THEN (26)
IF (51-55), THEN (25)
IF (56-61), THEN (24)
IF  (62 >), THEN (23)

stephen,

If you are trying to do this just in the workbook, you could always create a list and then do a vlookup to get the value, this would save you a lot of time. You would not even have to write a single if statement.

Hi Stephen

You can nest up to 64 IF statements in one cell where =IF(A1>=62,.23,IF(A1>=56,.24,IF(A1>=51,.25...and so on. Using VLOOKUP would be much easier than nesting 23 IF statements though.

Thanks for the quick answers! Having the data on a separate tab does seem a lot easier, but the VLookup command seems complicated as all get out.

Here's an example. Put your data on a seperate sheet and reference just the same.


Book2.xlsx

Apt Load Calc (Bldg).xlsx

Here you go amotto11.

stephen just post your sheet and i will finish it for you

Here you go Stephen.

Apt%20Load%20Calc%20%28Bldg%29(1).xlsx

I tweaked it a bit, but got it to work as intended.

Thanks, mmogharreban!!