=IF(OR([Room number]>=1100,[Room number]<1900),"1100-1800",
(OR([Room number]>=2100,[Room number]<2900),"2100-2800",
(OR([Room number]>=3100,[Room number]<3900),"3100-3800",
(OR([Room number]>=4100,[Room number]<4900),"4100-4800",
("")))))
=IF(OR([Room number]>=1100,[Room number]<1900),"1100-1800",
(OR([Room number]>=2100,[Room number]<2900),"2100-2800",
(OR([Room number]>=3100,[Room number]<3900),"3100-3800",
(OR([Room number]>=4100,[Room number]<4900),"4100-4800",
("")))))
=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",
...
)
If you are experiencing a similar issue, please ask a related question
Title | # Comments | Views | Activity |
---|---|---|---|
Sharepoint SQL Server Database (WSS_Logging) stuck in "restoring" mode | 12 | 45 | |
Sharepoint List View | 6 | 30 | |
Sharepoint 2012 site not live after migration | 7 | 56 | |
SharePoint 2013 List with Ratings | 6 | 32 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!