if and

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

• Home
• Courses
• Promotions
• Schedule
• Formats
• Our Clients

# IF and &

Resolved · Urgent Priority · Version 2016

Maisie has attended:
Excel Intermediate course

### IF and &

I am getting an errors NAME?

Cell H9 has HKD
Cell I9 has 788
Formula in K9 =IF(H9=HKD,I9&" HK equity",F)

I'm trying to get the results 788 HK equity

Also having trouble with a nested IF formula
Cell H10 has USD
Cell I10 has BILI
Cell H11 has CNY
Cell I11 has 000001
Formula in K10 =IF(H10=HKD,I9&" HK equity",IF(H10=USD,I10&" US equity",IF(H10=CNY,I11&" CH equity")))

I'm trying to get results in cell K10 of BILI US equity
I'm trying to get results in cell K11 of 000001 CH equity

The cell formats are text.

### RE: IF and &

Hi Maisie,

Thank you for the forum question.

Change this:
Formula in K9 =IF(H9=HKD,I9&" HK equity",F)

To:
Formula in K9 =IF(H9="HKD",I9&" HK equity","F")

All text must be inside ""

And change:

Formula in K10 =IF(H10=HKD,I9&" HK equity",IF(H10=USD,I10&" US equity",IF(H10=CNY,I11&" CH equity")))

To:

Formula in K10 =IF(H10="HKD",I9&" HK equity",IF(H10="USD",I10&" US equity",IF(H10="CNY",I11&" CH equity")))

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

Training information:

 Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions What does 'Resolved' mean? Any suggestions, questions or comments? Please post in the Improve the forum thread.

### Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips