Solved

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

Posted on 2016-11-28
2
30 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 33

Accepted Solution

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

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

Author Closing Comment

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

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

803 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