Getting Invalid error in Logic

Options
suruchi.kapoor
suruchi.kapoor Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 New Contributor
in Planning & Modeling

IF 'Headcount Capacity 2' 'Seatings.Less than 50 seats' THEN 'S' ELSE IF 'Headcount Capacity 2' 'Seatings.50-200 seats' THEN 'M' ELSE IF 'Headcount Capacity 2' 'Seatings.201 - 500 seats' THEN 'L' ELSE IF 'Headcount Capacity 2' 'Seatings.More than 501 seats' THEN 'XL' ELSE 'Headcount Capacity 2'

 

This is refernce to Calculate Office size when user enter data  in Headcount so office size need to calculate with this logic either small or medium.

 

 

 

Tagged:

Comments

  • suruchi.kapoor
    suruchi.kapoor Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 New Contributor

    Thank Akhtar ...It helped. i have tried in same manner and it worked 

Categories