Wow !! It worked for me !! You solved my problem at just one go, i have been struggling at this for long...I just had to prepare my report quickly for my boss and fortunately came to your solution, really you are a genius. Thank you so much for your video and guidance on Absolute cell reference. I will now remember for rest of my career !! Thank you so much & God bless !! :)
Hi, I tried this and for some reason the resulting value is the same exact value from the cell in which I created the formula. For example, as you have here, your first cost came up as 6,000 and for me, when I drag the formula down, it just copies 6000 all the way down. The value only changes to the correct amount when I click on each individual cell and then click the formula bar. Is there a setting that is off on my program? Please help if you can : )
Hello, there is an online template in excel called Automotive repair tracker, it has only two vehicles thus vehicle 1 and vehicle 2. I want to use the same template for more than two vehicles but I can't edit the functions and formulas used. Kindly give me a tutorial on that template