Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
=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 |
---|---|---|---|
Dynamic content on SharePoint 2013 | 13 | 90 | |
Intranet and Kerberos Authentication (not sharepoint!) | 8 | 132 | |
SharePoint 2013 Blog Template | 2 | 46 | |
How to download files/folders from Office 365 SharePoint? | 2 | 96 |
Join the community of 500,000 technology professionals and ask your questions.