| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tweaking formula?
Cell "L1" is used only for the first year which is prorated, "After" the
first year I need it to show a 10 in cell "L1" This is what I have now in cell "L1" =IF(TODAY()-B16<90,0,INT((DATE(YEAR(B16),12,31)-B16)*0.0274)+0.5) This is what I have in cell "A3" =IF(DATEDIF(B16,TODAY(),"Y")11,20,INT(VLOOKUP(DAT EDIF(B16,TODAY(),"Y"),K:L,2,0))&" Days "&8*MOD(VLOOKUP(DATEDIF(B16,TODAY(),"Y"),K:L,2,0), 1)& " hours") |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Tweaking formula?
Richard wrote:
Cell "L1" is used only for the first year which is prorated, "After" the first year I need it to show a 10 in cell "L1" This is what I have now in cell "L1" =IF(TODAY()-B16<90,0,INT((DATE(YEAR(B16),12,31)-B16)*0.0274)+0.5) This is what I have in cell "A3" =IF(DATEDIF(B16,TODAY(),"Y")11,20,INT(VLOOKUP(DAT EDIF(B16,TODAY(),"Y"),K:L,2,0))&" Days "&8*MOD(VLOOKUP(DATEDIF(B16,TODAY(),"Y"),K:L,2,0), 1)& " hours") Hi Richard, and what about cell B16? -- Thanks in advance for your feedback. Ciao Franz Verga from Italy |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Tweaking formula?
B16 is the Actual Hire Date
"Franz Verga" wrote: Richard wrote: Cell "L1" is used only for the first year which is prorated, "After" the first year I need it to show a 10 in cell "L1" This is what I have now in cell "L1" =IF(TODAY()-B16<90,0,INT((DATE(YEAR(B16),12,31)-B16)*0.0274)+0.5) This is what I have in cell "A3" =IF(DATEDIF(B16,TODAY(),"Y")11,20,INT(VLOOKUP(DAT EDIF(B16,TODAY(),"Y"),K:L,2,0))&" Days "&8*MOD(VLOOKUP(DATEDIF(B16,TODAY(),"Y"),K:L,2,0), 1)& " hours") Hi Richard, and what about cell B16? -- Thanks in advance for your feedback. Ciao Franz Verga from Italy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locking portions of a formula | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
