Thread: iserror
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dnmusic dnmusic is offline
external usenet poster
 
Posts: 5
Default iserror

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...