Problems calculating results of an if statement

[Iain Palmer]

I have created a simple formula which is '=IF(B3="","",B3*$C$2)' this is in c3, there are four of them for example the one is'=IF(D3="","",D3*E$2)' and so on. What i want to do is add the result of the four totals but when the cell is blank i get #value, but when b,d,f or g isn't blank it works the formula for this is simply '=C3+E3+G3+I3'. Because of the number of rows that will be used i don't really want 0 in the blank cells. I know there must be a simple way to sort it out any help would be appreciated

[XLent]

use SUM

Please Login or Register  to view this content.

unlike + the above will not try and coerce the values (to number), a text string (incl. null string) coerced will generate #VALUE! unless the string itself is numeric (e.g. "7")

[Iain Palmer]

Thank you knew it had to be something simple