Formula with text

[DD]

We do fixed assets on excel spreadsheet. Each worksheet
is an new month. Formula is =K47*$M$2. The M represents
the current month (7) and this number is entered on Row 2
M. We acquired the new asset in February and we only want
to depreciate it for six months. This formula no longer
works if we enter the current month of (7) in M. Can you
help me?

 

[Paul Corrado]

DD,

What does the K47*M2 represent with respect to the fixed assets or what is
K47?

When you say you only wish to depreciate the new asset for 6 months, is that
its entire useful life or are you taking a 1/2 year convention where 1/2 of
the annual depreciation is recorded in the year an asset is placed into
service? In this case the monthly straight line depreciation for this year
would be (total cost/years*.5) and the monthly amount would be (total
cost/years*.5)/(12-month purchased)

Or, are you doing something else?

PC