Excel sum problem - need help

[ranger373v]

I need to create a formula that ignores blank cells or error cells(#VALUE!).
My current formula is:

=SUM(I24*L24)+(J24*M24*K24) - Result is placed in N24. I then have the
result from N24 copied into cell G24 for printing on a quotation.

Which returns the correct sum if a number exists in all cells. However if
cell I24 is blank I want the result in G24 to also be blank.

I tried using conditional formatting to make the number white (backround is
white) if there is an error, but, that did not work either.

Any help appreciated.

 

[Guest]

In G24 enter:
=IF(I24="","",N24)

 

[Don Guillett]

if(i24="","",yourformula)

 

[Guest]

Conditional formatting will also work witht his, but you need to make sure
the cell format is based on "Formula Is" rather than "Cell Value Is" in the
Conditional Formatting form, then the formula would be =IsError(cellref)

 

[ranger373v]

Thanks to all who responded. It will work. But, to add insult I also need to
add to the formula if the result is zero the result in G24 will also be blank.

if(i24="","",yourformula)

I need to create a formula that ignores blank cells or error
cells(#VALUE!).

[quoted text clipped - 11 lines]

Any help appreciated.

 

[Don Guillett]

then you should have said so

--
Don Guillett
SalesAid Software
(e-mail address removed)

Thanks to all who responded. It will work. But, to add insult I also need
to
add to the formula if the result is zero the result in G24 will also be
blank.

if(i24="","",yourformula)

I need to create a formula that ignores blank cells or error
cells(#VALUE!).

[quoted text clipped - 11 lines]

Any help appreciated.