| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula
Hello,
Need the date in A1, 1/21/05 to equal the number 1 for sum calculation. Help please. Thank you Susan |
|
#2
|
|||
|
|||
|
Whgt should happen in the sum calculation for dates other than 1/21/05?
In article , "Susan" wrote: Need the date in A1, 1/21/05 to equal the number 1 for sum calculation. Help please. Thank you |
|
#3
|
|||
|
|||
|
The date should equal 1
"JE McGimpsey" wrote: Whgt should happen in the sum calculation for dates other than 1/21/05? In article , "Susan" wrote: Need the date in A1, 1/21/05 to equal the number 1 for sum calculation. Help please. Thank you |
|
#4
|
|||
|
|||
|
Then why not just use 1 in your calculation?
In article , "Susan" wrote: The date should equal 1 |
|
#5
|
|||
|
|||
|
"Susan" wrote: Hello, Need the date in A1, 1/21/05 to equal the number 1 for sum calculation. Help please. Thank you Susan I dont have your answer looking for one of mine own I need to caculated ending Value using cell referece contain the Numbers 281481.00 with the result being 2,641287.83 I am caculating investmens with input of 12.000 over a 20 year period. Constance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Linear Mode
