How does this formula work?

B

bignoiseny

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.
 
D

David Biddulph

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.
Click to expand...

You've probably got names defined.
Try Insert/ Names/ Define, and see what's there.
 
Top