View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default what should be simple

Hi,

Maybe something like the in G2 & O2

=IF(N2<"",K2/N2,"")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Rene" wrote:

b2 =min(g2,o2,w2,ae2)
g2 =k2/n2
o2 =s2/v9
...

b2 works when all the cell formulas have data to compute, but does not work
when one of the formulas returns the error msg #div (no data)

Thanks for your help