How to apply formula to cell based on IF condition in Excel
- by Captain Comic
Hi
I have an Excel spreadsheed like the one shown below
A B
10.02.2007 10
10.03.2007 12
Column A is date and B is price of share
Now in another sreadsheet I need to create a new column called return
In this column i need to place formula like = ln(B2/B1)
but on condition that this formula is only applied date in column A is in range
StartDate < currentDate < EndDate.
So I want to
apply my formula only to specific period say only to 2007 year
have new column placed in another spreadsheet starting from given location say A1
Please suggest