Numerical problems connecting several cells
[Users questions | Browse:38 | Favorites]
Users questions: Requirements: a few cells in the left lateral link up the number, if a cell is empty is zero. Found with the formula cell if the connection is empty does not appear after "0" value. At this point, you ask to modify the formula to make it display the correct value. Thank you.
Experts answer:E2 the following formula: = IF (AND (A2 = "", B2 = "", C2 =""),"",( IF (A2 = "", 0, A2) & IF (B2 = "", 0, B2) & IF (C2 = "", 0, C2))) E2 the following formula: = IF (A2 = "", 0, A2) & IF (B2 = " ,0,B2)&IF(C2= ,0,C2))
Experts answer:E2 the following formula: = IF (AND (A2 = "", B2 = "", C2 =""),"",( IF (A2 = "", 0, A2) & IF (B2 = "", 0, B2) & IF (C2 = "", 0, C2))) E2 the following formula: = IF (A2 = "", 0, A2) & IF (B2 = " ,0,B2)&IF(C2= ,0,C2))
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.