Sep 24 2019 08:53 AM
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)")))
Sep 24 2019 01:38 PM - edited Sep 24 2019 01:38 PM
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
Sep 25 2019 12:04 AM
thanks this now works - i think i'd actually made an error in my typing. But thanks for your help - @Sergei Baklan
Sep 25 2019 12:10 AM
can i add more options to this formula? i would like 4 or 5 options in there. currently there are 2@Sergei Baklan
Sep 25 2019 12:15 AM
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
Sep 25 2019 12:17 AM
Please ignore previous messages, i have figured it out. Many thanks
Sep 25 2019 02:45 PM
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)
Sep 27 2019 06:53 AM
@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.
Sep 27 2019 11:01 AM
Sorry, but I didn't catch. Could you please provide small sample to illustrate the task.