View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default more help on INT, MOD

I don't see where A8 is used in any formula.

What does "cannot read cell A3" mean?

If it means that you type a number in that cell and A8 doesn't add it correctly,
you may have text masquerading as numbers.

Try formatting A3 as General and then reenter that number in A3 (do both
things!).

Richard wrote:

This is in cell
A3...=IF(DATEDIF(B16,TODAY(),"Y")11,20,INT(VLOOKU P(DATEDIF(B16,TODAY(),"Y"),K:L,2,0))&"
days "&8*MOD(VLOOKUP(DATEDIF(B16,TODAY(),"Y"),K:L,2,0), 1)& " hours")
This formula fixed one problem but now caused another one. Cell A8 has the
formula =A3+B3+F4+F5+F6. With the new formula it cannot read Cell A3. Any
suggestions?


--

Dave Peterson