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.

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.

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.

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

How does this formula work?
 

Thanks for the answer!!!