- May 9, 2006
- 1,808
- 0
- 36
Guys,
I've been creating an Excel spreadsheet to sort out my incoming/outcoming money so I can understand better where my money is going. So, I created it, blah blah blah, but I want to add a function that skips or equals a cell to '0' if the formulae doesn't find an integer (or real) number. For example:
I have this row:
item a | 250
item b | 350
item c | 45
total : | =B1+B2+B3
Where B1 through B3 are the cells with the numbers above.
The thing is, if I put an symbol before the number to avoid a certain cell, the returned value is '#VALUE' instead of an actual numbers - because Excel can't make calculation with symbols (duh!). So is there an easy way to do this thing (if excel finds a symbol or something that is not an integer or a real number, suppose it is '0') without using VBA or Macros or something ? I thought of a loop, from my Pascal programming days, but I don't have a clue if Excel accepts it.
I've been creating an Excel spreadsheet to sort out my incoming/outcoming money so I can understand better where my money is going. So, I created it, blah blah blah, but I want to add a function that skips or equals a cell to '0' if the formulae doesn't find an integer (or real) number. For example:
I have this row:
item a | 250
item b | 350
item c | 45
total : | =B1+B2+B3
Where B1 through B3 are the cells with the numbers above.
The thing is, if I put an symbol before the number to avoid a certain cell, the returned value is '#VALUE' instead of an actual numbers - because Excel can't make calculation with symbols (duh!). So is there an easy way to do this thing (if excel finds a symbol or something that is not an integer or a real number, suppose it is '0') without using VBA or Macros or something ? I thought of a loop, from my Pascal programming days, but I don't have a clue if Excel accepts it.