Be seen. Boost your question’s priority for more expert views and faster solutions
=IF(([Room number]>=1100 && [Room number]<1900),"1100-1800",
IF(([Room number]>=2100 && [Room number]<2900),"2100-2800",
IF(([Room number]>=3100 && [Room number]<3900),"3100-3800",
IF(([Room number]>=4100 && [Room number]<4900),"4100-4800",
("")))))
=IF((([Room number]>=1100) AND ([Room number]<1900)),"1100-1800",
IF((([Room number]>=2100) AND ([Room number]<2900)),"2100-2800",
IF((([Room number]>=3100) AND ([Room number]<3900)),"3100-3800",
IF((([Room number]>=4100) AND ([Room number]<4900)),"4100-4800",
("")))))
=IF( ([Room number]<1900), "1100-1800",
IF( ([Room number]<2900), "2100-2800",
IF( ([Room number]<3900), "3100-3800",
IF( ([Room number]<4900), "4100-4800",
("") ))))
=IF( ([Room number]<1900), "1100-1800",
IF( ([Room number]<2900), "2100-2800",
IF( ([Room number]<3900), "3100-3800",
IF( ([Room number]<4900), "4100-4800",
("") ))))
&
IF( ([Room number]<4900), "",
IF( ([Room number]<5900), "5100-1800",
IF( ([Room number]<6900), "6100-2800",
IF( ([Room number]<7900), "7100-3800",
("") ))))
&
...
IF( OR( AND(([Room number]>=3600),([Room number]<=3999)),
AND(([Room number]>=4100),([Room number]<=4299)) ), "Bldgs. 36-39",
...
)
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Open in new window