I have tried to combine the following If statements
=IF(F7="Office",C5)
IF(f7="Retail",D5,)
IF(F7="Residential",E5)
But rather then give me values it gives me False or True, how would I combine these so that It gives me the corresponding values (C5:E5)
Many thanks
Bookmarks