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?

Hi Chris,
I don't encounter that problem using Excel 2000. Which version are you using?

hth

2000.
Hmmmm

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?

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

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.