Dear All,
I am trying to calculate Written Down Value Rate for calculating
depreciation on the basis of WDV method by using the following formula.
Rate = [1 - (Scrap Value / Total Cost ) ^ (1/Life) ] * 100
If the life is in Number of Exact years, the rate derived is accurate, but
if the life of
Try Excel Power Programming by John Walkenbach
and for online tutorials visit
http://www.andypope.info/links.htm#forums
On Sat, Aug 16, 2014 at 9:24 AM, Ruchi Sharma wrote:
> Hi,
>
> I do not have much knowledge of VBA but wanted to learn it. Can you refer
> some book? So that I can start wit
Hi,
I do not have much knowledge of VBA but wanted to learn it. Can you refer some
book? So that I can start with the self study.
Thanks,
Ruchi
Sent from my iPhone
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook p
Dear Mr Joshi.
Thank for your consider.Enclosed is file to you reference.
Best regards
Son
2014-08-13 16:05 GMT+07:00 Vaibhav Joshi :
> hi
>
> can you share a sample data in excel sheet.
>
> Thanks
>
>
> On Wed, Aug 13, 2014 at 1:57 PM, son nguyen wrote:
>
>> Dear Expert.
>>
>> I faced on pro
Good try, but no what I simply need is an some kind of event mechanism
to make things as idiot proof for the operator using this.
In cell K1 - The operator has the option of entering either A, D Or P.
A = ALL records
D = Only records where cell E6 onwards > 113000 AND ALL BLANK RECORDS
At E2 (sheet Advanced Filter), Select >=113 300 or <=10
To get results.
2014-08-14 22:12 GMT+07:00 Paul Schreiner :
> I don't believe you can do it with a FORMULA.
> But you can do it with a Change Event macro.
>
> You would create an autoFilter for rows 5-###
> Then, record a macro in wh
