Reducing Balance Formula

B

Badger

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
 
B

Badger

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

Al Campagna said:
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:
Badger said:
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
Click to expand...
Click to expand...
 
A

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

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

Al Campagna said:
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:
Badger said:
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
Click to expand...
Click to expand...
Click to expand...
 
Top