98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » IF and &
IF and &
Resolved · Urgent Priority · Version 2016
Tue 16 Mar 2021, 16:06Delegate 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:17Trainer 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 information:
See also:
|
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Do a fast scrollIn 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. |
