View Single Post
  #23   Report Post  
Posted to microsoft.public.excel.misc
dnmusic dnmusic is offline
external usenet poster
 
Posts: 5
Default iserror

ok, i have a formula that works but i want to have the cell blank when
nothing is in the other cells... =IF(ISERROR(F4/E4,0,F4/E4) which gives me
0.00 in cell G4. question is, what do i need to add to the formula to have
G4 blank until valves are added to cells F4 and E4... i.e. ,"", but i can't
get it right... any help?