• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

×One Formula

hi
I have Table 1 I want to become like Table 2 (only one equation in column Q)
Explanation of the first table:
Is the first 3 years apply discount 4% - 8% - 17.7% respectively and then from the beginning of the fourth year apply the same rates of the previous discount in addition to the rest of the first three years
thank you very much
 

Attachments

vletm

Excel Ninja
Mamdouh Elfors
As You wrote:
I have Table 1 I want to become like Table 2 (only one equation in column Q)
Didn't You want to delete that Table 1 or what?
If You want to keep Table 1 then
for cell P3 =i3 and
for cell Q3 =m3
and copy down...
 
Last edited:
Top