Excel EXCEL: help with the IF function

Joined
Jul 31, 2015
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top