| 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
more help on INT, MOD
The text strings of " days" and " hours" in the formula makes the content of
A3 text format. Therefore you can't add it with other cells. Just need to change formula so A3 shows same type of numbers as other cells to add. -Simon "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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
more help on INT, MOD
Please ignore this post.
I didn't see that that formula was located in A3. Maybe you can use B16 in the sum formula? Dave Peterson wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
