Forum Discussion
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="Cop...
If replace doubled single apostrophes on double apostrophes the formula works
=IF(F9="Copier desk", "DK-510 Copier desk", IF(F9="500 Sheet tray","PF-514"))
But I'm not sure when that was introduced, typing the post or in Excel
Please ignore previous messages, i have figured it out. Many thanks