?
Solved

In Excel 2007, how do I need to correct this ampersand formula so it works?

Posted on 2016-11-28
2
Medium Priority
?
42 Views
Last Modified: 2016-11-28
This is the current formula I have now:

=IFERROR(IF(C9="volt";"Omräknade till "&C8&" "volt";"Omräknade till "&C8&" "auto");"")

But there is something wrong with it, where I have entered "volt" and "auto". What is wrong with the formula?
0
Comment
Question by:hermesalpha
2 Comments
 
LVL 37

Accepted Solution

by:
Norie earned 2000 total points
ID: 41905154
Try this.

=IFERROR(IF(C9="volt";"Omräknade till " & C8 & "volt";"Omräknade till " & C8 & "auto");"")
0
 
LVL 1

Author Closing Comment

by:hermesalpha
ID: 41905164
Thanks, that worked.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Excel allows various different methods to link Excel files to each other. This includes relative paths, mapped drives (or the local drive) and UNC paths. UNC paths are the least robust of the three.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question