| [ Total Views: 515 | Total Replies: 5 | Thread Id: 66699 ] |
|
|
 amazeer
A.k.a.: Surly Duff
Bishop of Volkswagenism
Posts: 3029
Threads: 387
Registered: November 14th, 2005
Member Is Offline
Location: Wollongong
Theme: UltimaBB Pro Blue ( Default )
Mood: bitter
|
| posted on December 26th, 2007 at 02:29 PM |
|
|
excel help wanted
when I use the result of an if statement I get the #value error in the image.
I can use =IF(ISNUMBER(K2),L2/K2,0) like I have in the lower rows, but I dont really want to display a zero there if its not needed.
Can anyone tell me a solution?
| Error |
| Sorry, you must be a registered user in order to download attachments. |
|
|
|
|
modulus
A.k.a.: Peter Hill
Veteran Volks Folk
Posts: 2009
Threads: 76
Registered: July 1st, 2003
Member Is Offline
Location: Melbourne
Theme: UltimaBB Pro White
Mood: modular
|
| posted on December 26th, 2007 at 03:53 PM |
|
|
Hi Chris,
I don't encounter that problem using Excel 2000. Which version are you using?
hth
| Error |
| Sorry, you must be a registered user in order to download attachments. |
|
|
|
|
amazeer
A.k.a.: Surly Duff
Bishop of Volkswagenism
Posts: 3029
Threads: 387
Registered: November 14th, 2005
Member Is Offline
Location: Wollongong
Theme: UltimaBB Pro Blue ( Default )
Mood: bitter
|
| posted on December 26th, 2007 at 05:13 PM |
|
|
2000.
Hmmmm
|
|
|
modulus
A.k.a.: Peter Hill
Veteran Volks Folk
Posts: 2009
Threads: 76
Registered: July 1st, 2003
Member Is Offline
Location: Melbourne
Theme: UltimaBB Pro White
Mood: modular
|
| posted on December 26th, 2007 at 05:52 PM |
|
|
My sum formula is =SUM(C2:E2).
Is that what you're using (i.e. it may work differently from e.g. =C2+D2+E2?
|
|
|
modulus
A.k.a.: Peter Hill
Veteran Volks Folk
Posts: 2009
Threads: 76
Registered: July 1st, 2003
Member Is Offline
Location: Melbourne
Theme: UltimaBB Pro White
Mood: modular
|
| posted on December 26th, 2007 at 06:05 PM |
|
|
Yep, after having a look at the help:
"
SUM(number1,number2, ...)
Number1, number2, ... are 1 to 30 arguments for which you want the total value or sum.
Numbers, logical values, and text representations of numbers that you type directly into the list of arguments are counted. See the first and second
examples following.
If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in
the array or reference are ignored. See the third example following.
Arguments that are error values or text that cannot be translated into numbers cause errors.
"
So it matters more how you specify the addition than whether it contains nulss, empty strings ewtc.
hth
|
|
|
amazeer
A.k.a.: Surly Duff
Bishop of Volkswagenism
Posts: 3029
Threads: 387
Registered: November 14th, 2005
Member Is Offline
Location: Wollongong
Theme: UltimaBB Pro Blue ( Default )
Mood: bitter
|
| posted on December 27th, 2007 at 12:18 PM |
|
|
thanks man.
=SUM(C3:F3, G3*12, H3*15, I3*20, J3*15, M3) works a treat.
=C7+D7+E7+F7+(G7*12)+(H7*15)+(I7*20)+(J7*15)+M7 is what I was using before.
|
|
|
