IF(ISERROR) help

[mooseboy]

This is my current cell(N3) and it works great:
=IF(L3>=10.01,((M3*8)+((M3*1.5)*(10-8))+((M3*2)*(L3-10))),IF(L3>=8.01,((M3*8)+((M3*1.5)*(L3-8))),IF(L3>0,L3*M3,"-")))

BUT, I would like a bit more help please

The adjacent cell is this, it sums four separate cells, of which the above is one of them
=IF(ISERROR(E3+H3+K3+N3),"-",E3+H3+K3+N3)

So if N3 is "-", it does not recognize E3+H3+K3+ (-) = (-)
How can an ISERROR be added to cell N3 ?
I could put ,"$0.00" in place of the ,"-" at the back end of cell N3 but it doesn't look as pretty...

 

[Fluff]

If N3 is "-" do you still want to add the other 3 cells, or just return"-"?

 

[mooseboy]

If N3 is "-" do you still want to add the other 3 cells, or just return"-"?

need to still add all four cells

 

[Fluff]

In that case try

=SUM(E3,H3,K3,N3)

 

[mooseboy]

In that case try

=SUM(E3,H3,K3,N3)

that brings up the #Value! error as one of those cells may have "-" in it

 

[Fluff]

That formula will not return an error, unless one of the cells contains an error.

 

[mooseboy]

That formula will not return an error, unless one of the cells contains an error.

the cells will return a "-" unless there are calculated numbers within them
example: cells E3 and K3 may have monetary numbers within them while cells H3 and N3 have nothing and return "-"

 

[Fluff]

The formula I suggested will simply ignore text, it will not return an error unless one of the cells it's looking at returns an error.
So if you are getting an error & none of the cells contains an error, then you are not using the formula I posted.

 

[mooseboy]

That formula will not return an error, unless one of the cells contains an error.

Sorry, I had E3+H3+K3+N3
should have had ,,,,

Thank you

 

[Fluff]

Glad to help & thanks for the feedback.