# Excel IF help

Highlighted
Occasional Contributor

# 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)")))

8 Replies
Highlighted

# Re: Excel IF help

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

Highlighted

# Re: Excel IF help

thanks this now works - i think i'd actually made an error in my typing. But thanks for your help - @Sergei Baklan

# Re: Excel IF help

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

Highlighted

# Re: Excel IF help

This for example - =IF(F9="Copier desk", "DK-510 Copier desk", IF(F9="500 Sheet paper feed cabinet","PF-514", if(f9= ''TWO 500 Sheet paper feed cabinet'',''PC-512''))) - but this doesnt work@Sergei Baklan

Highlighted

# Re: Excel IF help

Please ignore previous messages, i have figured it out. Many thanks

Highlighted

# Re: Excel IF help

Okay, so far so good. As a comment, better not to hardcode your texts into the formulas, but put the in some helper range, like

With that your formula could be transformed to

``=LOOKUP(F9,\$B\$1:\$B\$10,\$C\$1:\$C\$10)``
Highlighted

# Re: Excel IF help

@Sergei Baklan sorry from the last message - i would like to add items from sheet 2 to the top of sheet 4 if nothing selected from sheet 1.

Highlighted

# Re: Excel IF help

Sorry, but I didn't catch. Could you please provide small sample to illustrate the task.