Hi guys i am wet behind the ears when it comes to certain formulas and have a problem i hope one of you can solve for me.
I have multiple apartments from 1A 1B to 24A-24B so basically 48 (apartments)values and when a value is entered the one particular cell i need other values to change. Below is a formula that is working for me for 3 true and one false how do i do it for 48 true values?? forgive me if i am using wrong terminology.
flat 6a
flat 6b
flat 7a
=IF(W16="6a",E7, IF(W16="6b",E8, IF(W16="7a",E9, "")))
how would i do this for 48 apartments.
your help would be greatly appreciated.
) K
I have multiple apartments from 1A 1B to 24A-24B so basically 48 (apartments)values and when a value is entered the one particular cell i need other values to change. Below is a formula that is working for me for 3 true and one false how do i do it for 48 true values?? forgive me if i am using wrong terminology.
flat 6a
flat 6b
flat 7a
=IF(W16="6a",E7, IF(W16="6b",E8, IF(W16="7a",E9, "")))
how would i do this for 48 apartments.
your help would be greatly appreciated.
) K