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