Thread
:
How does this formula work?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Ardus Petus
Posts: n/a
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.
Reply With Quote