View Single Post
  #24   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default iserror

Maybe this:

=IF(COUNT(E4:F4)=2,F4/E4,"")

--
Biff
Microsoft Excel MVP


"dnmusic" wrote in message
...
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?