IF and &

Resolved · Urgent Priority · Version 2016

Tue 16 Mar 2021, 16:06 Delegate Maisie said...

Maisie has attended:
Excel Advanced course
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.

Tue 16 Mar 2021, 16:17 Trainer Jens said...

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

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

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