VeeamÂ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
=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
Join the community of 500,000 technology professionals and ask your questions.