# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need 2 formulas: 1. salvage value? where initial cost item is in column C, effective life of 10 yrs is in column D, diminishing value 20% is in column E, Salvage Value ? is in column F. 2. then need formula for WDV to be located in column G.
Solved by V. D. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 23/10/2017 - 04:20
Hi there, Thanks for choosing Got It Pro-Excel! How may I help you today?
Excelchat Expert 23/10/2017 - 04:22
You need Salvage Value correct?
User 23/10/2017 - 04:22
Yes . I just need the correct inputs for excel.
Excelchat Expert 23/10/2017 - 04:22
Sure
Excelchat Expert 23/10/2017 - 04:23
As per my understanding, the formula for Salvage value is given as:
User 23/10/2017 - 04:23
Would you like me to plug in some values on the sheet opposite
Excelchat Expert 23/10/2017 - 04:24
Salvage value =InitialCost*[(1-%diminishing)^years]
Excelchat Expert 23/10/2017 - 04:24
I can put in the formula
Excelchat Expert 23/10/2017 - 04:24
and then you can play with the values
User 23/10/2017 - 04:24
This will be part A.
User 23/10/2017 - 04:24
Then l will need part B which is the WDV
Excelchat Expert 23/10/2017 - 04:25
The formula for Salvage value is in Column F
Excelchat Expert 23/10/2017 - 04:25
=C2*((1-E2)^D2)
Excelchat Expert 23/10/2017 - 04:25
Can you give me the full form of WDV?
Excelchat Expert 23/10/2017 - 04:26
as in what does WDV stand for?
Excelchat Expert 23/10/2017 - 04:28
Does it stand for Written Down Value?
Excelchat Expert 23/10/2017 - 04:29
Salvage value =InitialCost*[(1-%diminishing)^years]
User 23/10/2017 - 04:29
This is what l am after
Excelchat Expert 23/10/2017 - 04:30
I have found a formula for WDV
Excelchat Expert 23/10/2017 - 04:30
but it needs 2 more inputs
User 23/10/2017 - 04:30
hmm..It shouldnt
Excelchat Expert 23/10/2017 - 04:30
Date of purchase and Calculation date
User 23/10/2017 - 04:31
assume 30.06. for each financial period
User 23/10/2017 - 04:31
annual
User 23/10/2017 - 04:34
ahhh...can we assume for the exercise the wdv is after 5 years
Excelchat Expert 23/10/2017 - 04:35
Ok Hold on
Excelchat Expert 23/10/2017 - 04:36
So I have entered the formula
User 23/10/2017 - 04:36
wow
Excelchat Expert 23/10/2017 - 04:36
That takes in the 2 dates mentioned
User 23/10/2017 - 04:36
thats a big formula
Excelchat Expert 23/10/2017 - 04:36
you can change those dates
Excelchat Expert 23/10/2017 - 04:36
if you like to consider the period you want
Excelchat Expert 23/10/2017 - 04:36
I will explain the formula
Excelchat Expert 23/10/2017 - 04:36
=C5*((1-E5)^((DATEDIF(I5, H5, "D")+1)/365))
Excelchat Expert 23/10/2017 - 04:37
The datedif part calculates the number of days between 2 dates
Excelchat Expert 23/10/2017 - 04:37
The formula is as follows:
Excelchat Expert 23/10/2017 - 04:37
WDV as on Date = Cost price x (1- Dep Rate%) ^ (Date of WDV Calculation - Date of Purchase + 1)/365
Excelchat Expert 23/10/2017 - 04:38
So you can put in the dates you want in the 2 columns after Col G
User 23/10/2017 - 04:39
Perfect
User 23/10/2017 - 04:39
That helps me alot
User 23/10/2017 - 04:39
much appreciated
Excelchat Expert 23/10/2017 - 04:39
Great
Excelchat Expert 23/10/2017 - 04:40
Do you need any clarification on any formula
Excelchat Expert 23/10/2017 - 04:40
?
User 23/10/2017 - 04:40
so can l copy and paste this formula
Excelchat Expert 23/10/2017 - 04:40
Copy paste where?
User 23/10/2017 - 04:43
1 more minute and then we are all good
Excelchat Expert 23/10/2017 - 04:43
no problem
User 23/10/2017 - 04:46
I cant find the up arrow symbol
User 23/10/2017 - 04:46
Just before D5
Excelchat Expert 23/10/2017 - 04:46
It will be above the number 6
Excelchat Expert 23/10/2017 - 04:46
press shift + 6
User 23/10/2017 - 04:46
ahh yes
User 23/10/2017 - 04:46
thankyou
User 23/10/2017 - 04:46
I feel like a goose
User 23/10/2017 - 04:47
So will this formula stay on the page for a few minutes
Excelchat Expert 23/10/2017 - 04:47
i think so
Excelchat Expert 23/10/2017 - 04:47
but if you maintain the columns as it is
Excelchat Expert 23/10/2017 - 04:47
then you can copy this formula in any sheet
Excelchat Expert 23/10/2017 - 04:47
for salvage value
Excelchat Expert 23/10/2017 - 04:48
=C5*((1-E5)^D5)
Excelchat Expert 23/10/2017 - 04:48
and for WDV
Excelchat Expert 23/10/2017 - 04:48
=C5*((1-E5)^((DATEDIF(I5, H5, "D")+1)/365))
User 23/10/2017 - 04:56
It works
User 23/10/2017 - 04:56
Cool
Excelchat Expert 23/10/2017 - 04:57
great
User 23/10/2017 - 04:57
Excelchat Expert 23/10/2017 - 04:57
Jeet
User 23/10/2017 - 04:57
Thanks Jeet
Excelchat Expert 23/10/2017 - 04:57
No problem
Excelchat Expert 23/10/2017 - 04:57
Thanks for using Got It Pro-Excel! Have a good day
User 23/10/2017 - 04:57
Hey l might call upon you again
User 23/10/2017 - 04:57
How do l get in touch again
Excelchat Expert 23/10/2017 - 04:58
You post another question in the same way
User 23/10/2017 - 04:58
Very Cool
Excelchat Expert 23/10/2017 - 04:58
and one of the experts will get in touch
User 23/10/2017 - 04:58
Thankyou
User 23/10/2017 - 04:58
Have a nice day
Excelchat Expert 23/10/2017 - 04:58
My pleasure

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.