| 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. |
| 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 | |||
Threaded Mode
