Excel IF help
i am creating an excel sheet to try and show a basic configurator. i have the following which shows that if copier desk is selected in call F9 then the cell will read DK-510 Copier desk. =IF(F9="Copier desk", "DK-510 Copier desk") i would like the cell to also say if f9 = 500 sheet tray then the cell will show PF-514. basically i want to be able to chose an option and show version of the option in the cell. the below works if a number is shown (for a different cell), but i need the same for the selected word/words - is this possible? i thought something like this - =IF(F9="Copier desk", "DK-510 Copier desk", IF(F9=''500 Sheet tray'',''PF-514'')) - but this doesnt work =IF(F3>657,"INEO+658 (Includes 2x 500 sheet cassette)",IF(F3>=558,"INEO+558 (Includes 2x 500 sheet cassette)",IF(F3>=458,"INEO+458 Includes 2x 500 sheet cassette)")))