| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
more help on INT, MOD
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? |
Threaded Mode
