i want to calculate 3 values in d15 col I have a formula =a1*a2*$a$3 and drag down upto d25
but in column d16 to m16 my formula changed to =$A$1*$B$1*D15 and drag to m16 which I changed manually.
from a1 to $a$1 first and then drag.
D15 E 15 F15
=A1*B1*$C$1 =$A$1*$B$1*D15 =$A$1*$B$1*E15
=A2*B2*$C$1
=A3*B3*$C$1
is there any formula to not to change this manually as my range of data is very large.
I am not able to understand what you want. can you please attach an Excel sheet, clearly showing the problem & the desired end result.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
sheet attached
The formula in E15 copies across perfectly. What do you want to happen in row 16??
Sir, at D15 the formula is =A1*B1*$C$1 and drop down to D24 but in the row D16:M16 I have to change this formula manually =$A$1*$B$1*D15 before stretch it to M16. So at E16 to E24 first I have to change this manually as above and then stretch to M16 to M24.
There is something in your description that I am not clear about. So... is this what you wnated (drag E15 down and then drag E15:E24 across.
If not what EXACTLY do you want in E15 and what EXACTLY do you want in E16?
Sir, Here is the result which I want. You can see that column D15:D24 copy to E15:E24 and then put the sign of $ to change absolute manually at E15,E16,E17,E18...E24.
All is clear now, I hope. Paste this into E15 and drag down and then across.
=$A1*$B1*D15
Thanks Glenn Kennedy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks