| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How does this formula work?
I found this formula
"=IF(D12="","",(D12/D$9)*1000*DaysInYear/DaysThisQtr)" in my spreadsheet. The formula result is 3.7 D12 = 54 D$9 = 59,350 I know the "DaysInYear" = 365 and "DaysThisQtr" = 90, but I don't know how the string text "DaysInYear" and "DaysThisQtr" were set to equal those values. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How does this formula work?
Have a look at InsertNameDefine
HTH -- AP a écrit dans le message de news: ... I found this formula "=IF(D12="","",(D12/D$9)*1000*DaysInYear/DaysThisQtr)" in my spreadsheet. The formula result is 3.7 D12 = 54 D$9 = 59,350 I know the "DaysInYear" = 365 and "DaysThisQtr" = 90, but I don't know how the string text "DaysInYear" and "DaysThisQtr" were set to equal those values. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How does this formula work?
Thanks for the answer!!!
|
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How does this formula work?
They are named ranges, look up 'Named Range' in Help
Regards, Alan. wrote in message oups.com... I found this formula "=IF(D12="","",(D12/D$9)*1000*DaysInYear/DaysThisQtr)" in my spreadsheet. The formula result is 3.7 D12 = 54 D$9 = 59,350 I know the "DaysInYear" = 365 and "DaysThisQtr" = 90, but I don't know how the string text "DaysInYear" and "DaysThisQtr" were set to equal those values. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How does this formula work?
wrote in message
oups.com... I found this formula "=IF(D12="","",(D12/D$9)*1000*DaysInYear/DaysThisQtr)" in my spreadsheet. The formula result is 3.7 D12 = 54 D$9 = 59,350 I know the "DaysInYear" = 365 and "DaysThisQtr" = 90, but I don't know how the string text "DaysInYear" and "DaysThisQtr" were set to equal those values. You've probably got names defined. Try Insert/ Names/ Define, and see what's there. -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does this Formula work? | Excel Worksheet Functions | |||
| Making this formula work | Excel Worksheet Functions | |||
| Formula do not work until edited | Excel Discussion (Misc queries) | |||
| IF / VLOOKUP formula won't work until saved | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
