Is there any other way to enter this formula
=IF(D6="common","invalid",IF(D6="vert","invalid",IF
(D6="core","invalid",IF(D6="mtg","invalid",IF
(D6="vacant","invalid","bus_unit")))))
I have around 30 room types (common, vert, etc) some are invalid and some are valid, the list will keep growing and I am running out of levels to nest the IF statement.
Thanks
=IF(D6="common","invalid",IF(D6="vert","invalid",IF
(D6="core","invalid",IF(D6="mtg","invalid",IF
(D6="vacant","invalid","bus_unit")))))
I have around 30 room types (common, vert, etc) some are invalid and some are valid, the list will keep growing and I am running out of levels to nest the IF statement.
Thanks