| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I don't need the actual value but what is shown
Hello. I have a cell F10 that needs that needs to be divided by the current
month. Example. D10 has a value of 100 and it needs to be divided by 10 because the current month is October. I tried to use in cell A10 Today() then format that cell to m and it shows the number 10. So that works fine but the result for F10 is 0 because the true value of that cell A10 is 10/28/2009. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I don't need the actual value but what is shown
try month(today()) - should return 10
-- hope to help, cm "Benny" wrote: Hello. I have a cell F10 that needs that needs to be divided by the current month. Example. D10 has a value of 100 and it needs to be divided by 10 because the current month is October. I tried to use in cell A10 Today() then format that cell to m and it shows the number 10. So that works fine but the result for F10 is 0 because the true value of that cell A10 is 10/28/2009. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I don't need the actual value but what is shown
=F10/MONTH(TODAY())
Regards, Stefi €˛Benny€¯ ezt Ć*rta: Hello. I have a cell F10 that needs that needs to be divided by the current month. Example. D10 has a value of 100 and it needs to be divided by 10 because the current month is October. I tried to use in cell A10 Today() then format that cell to m and it shows the number 10. So that works fine but the result for F10 is 0 because the true value of that cell A10 is 10/28/2009. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert 29.08 hours (shown in decimal form) to time shown in "hh:m | Excel Worksheet Functions | |||
| Column of Text Shown = Total Times Shown? | Excel Worksheet Functions | |||
| Formula bar and name box not shown | New Users to Excel | |||
| How do I get only the data I want to be shown? | Excel Discussion (Misc queries) | |||
| Named Ranges shown (or not shown) as blue means what? | Excel Worksheet Functions | |||
Linear Mode
