Forum Discussion

jh1979

Copper Contributor

Sep 24, 2019

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 command

SergeiBaklan

Diamond Contributor

Sep 24, 2019

jh1979

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

jh1979

Copper Contributor

Sep 25, 2019

can i add more options to this formula? i would like 4 or 5 options in there. currently there are 2SergeiBaklan