iserror

  • Thread starter Thread starter dnmusic
  • Start date Start date
D

dnmusic

ok, i have a formula =IF(ISERROR(F4/E4),0,F4/E4) which works fine bu i
need to know how to make that cell blank... i guess. the reason is that i'm
trying to get the average cell G4 thru G15 which on G16 i have the formula
-AVERAGE(G4:G15) but doesn't give me the correct average because the ISERROR
formula is creating 0.00 in the G cells. what formula and where do i need
it. i 've tried ,"", but i'm doing something wrong...
 
You had other suggestions at your other post.
ok, i have a formula =IF(ISERROR(F4/E4),0,F4/E4) which works fine bu i
need to know how to make that cell blank... i guess. the reason is that i'm
trying to get the average cell G4 thru G15 which on G16 i have the formula
-AVERAGE(G4:G15) but doesn't give me the correct average because the ISERROR
formula is creating 0.00 in the G cells. what formula and where do i need
it. i 've tried ,"", but i'm doing something wrong...
Click to expand...
 
Be careful using ISERROR.

It will mask all errors which may not be desirable.


Gord Dibben MS Excel MVP
 
Back
Top