=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",
...
)
Title | # Comments | Views | Activity |
---|---|---|---|
Sharepoint templates | 10 | 44 | |
SharePoint 2010 Errors on SBS2011 | 8 | 40 | |
How can I get a list of all SharePoint document libraries using UI? | 5 | 22 | |
Make SharePoint List Read Only and allow certain users to only see this list | 1 | 22 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!