Reducing Balance Formula

[Guest]

I'm doing asset register but some of our assets are depreciated by 10%
reducing balace. I cannot find anyway of using a 'x to the power of y'
formula where I would have [value] * [rate] to the power of [age of asset].

Can anyone help? or have I just confused the problem?

Many Thanks

 

[Al Campagna]

Badger,
Use the "^" operator to signify raisning a number to a power.
result = number^exponent
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."

The ^ operator syntax has these parts:

 

[Guest]

Thanks, can it used with fields? eg [rate]^[age]

Badger,
Use the "^" operator to signify raisning a number to a power.
result = number^exponent
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."

The ^ operator syntax has these parts:

I'm doing asset register but some of our assets are depreciated by 10%
reducing balace. I cannot find anyway of using a 'x to the power of y'
formula where I would have [value] * [rate] to the power of [age of
asset].

Can anyone help? or have I just confused the problem?

Many Thanks

 

[Al Campagna]

Yes.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."

Thanks, can it used with fields? eg [rate]^[age]

Badger,
Use the "^" operator to signify raisning a number to a power.
result = number^exponent
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."

The ^ operator syntax has these parts:

I'm doing asset register but some of our assets are depreciated by 10%
reducing balace. I cannot find anyway of using a 'x to the power of y'
formula where I would have [value] * [rate] to the power of [age of
asset].

Can anyone help? or have I just confused the problem?

Many Thanks