I'm trying to create a conditional formula to reflect Occupancy Load Factors if I insert a value into my Occupancy field.
For example I have:
Name | Number | Area | Area per Occupant | Occupancy| Occupancy Factor |
ROOM------1-------100-------------20-----------------B-----------------?---------------
Is there a way I can create a formula or something where if i type in B in OCCUPANCY, it will automatically fill OCCUPANCY FACTOR with 100, and if i type in A, it'll give me a different number?
For example I have:
Name | Number | Area | Area per Occupant | Occupancy| Occupancy Factor |
ROOM------1-------100-------------20-----------------B-----------------?---------------
Is there a way I can create a formula or something where if i type in B in OCCUPANCY, it will automatically fill OCCUPANCY FACTOR with 100, and if i type in A, it'll give me a different number?
Comment