I am creating a system (as part of my school project) which enables my end user to create invoices. My end user is a doctor and has asked me to present his system in a particular way.
Now, the real question: I have been trying to concatenate a range of cells, which include blanks, but i always end up with "#NAME?" or "#VALUE". I understand that i have to click on each cell if i want it to be concatenated, but like i said, some cells are blank (the cells differ from time to time).
How can i concatenate without a problem? please help
2007-02-09 22:41:31 · 3 answers · asked by Anonymous in Computers & Internet ➔ Programming & Design
In cell A1 I have "A"
In cell B1 I have a blank cell
In cell C1 I have "C"
In cell D1 I enter the formula "=A1&B1&C1"
The result in D1 is "AC"
There is no problem concatenating with blanks when using "&"
2007-02-10 01:59:48 · answer #1 · answered by Gene 3 · 2⤊ 0⤋
The IF assertion works like this: =if(logical try, consequence if genuine, consequence if fake) occasion: =if(5-3=2, "Yup", "Nope") ?in decision to the "consequence if genuine" ("Yup" interior the occasion) you may place yet another IF assertion finished with "if", parenthesis and the three components, and that they paintings a similar way. that's called nesting. you may then replace the "consequence if genuine" element of this new section with yet another IF assertion. This additionally works for the "consequence if fake" element of the formulation. Excel 2003 can nest as much as 7 IF applications, and Excel 2007 and 2010 the two enable sixty 4 nested IF applications. .
2016-11-03 01:35:36 · answer #2 · answered by roca 4 · 0⤊ 0⤋
Gene gave the right answer. I guess I'll just cash in for points and for confirmation of the info. :-) Good luck.
2007-02-10 02:46:04 · answer #3 · answered by Dave 5 · 0⤊ 0⤋