Hi all,
I've been using this formula in Excel.
=(INDIRECT("I"&COLUMN(AH1))-((E15-408)*1.138))*0.1
The issue that I'm having is that Excel seems to be ignoring AH1 in the formula.
Can anyone help me rewrite slightly so that it does?
Many thanks
D
Your formula refers to I34 (since column AH is column 34) - is that what you intended?
Thanks for your reply. This is what I've been working from.
=($E48-((B8-408)*1.138))*0.1
Does that help?
Not really since it doesn't relate to your original formula and I have no idea what your workbook looks like. Based on that formula, why do you refer to column I in your INDIRECT function? And why are you using INDIRECT at all?
The only reason I'm using it is because someone helped me in a previous post on here back in May. We've only just started using it, here's my original request.
the next formula across should be
=(I34-((E15-408)*1.138))*0.1
and the one after should be
=(I35-((F15-408)*1.138))*0.1
and so on and so forth - so the "i" bit should increase in number i34 - becomes i35
and the "15" bit should increase in letter so "E" becomes "F"
Can you help?
Thanks!
In that case your original formula is correct. Note that the contents of AH1 are irrelevant.
Ok, but if I chance =(I35-((F15-408)*1.138))*0.1 to =($I35-((F$15-408)*1.138))*0.1 for the increment, I can't keep some items static and other variable. ie. the 34 to 35.
Thanks
Sorry, meant to say *change
Why not? Your formula will not alter from column I - only the row number will change as you copy it across.
From this example. I need the 34 to go up to 35 as I drag across the rows, but 'I' to stay the same. Any chance?
=(I34-((E15-408)*1.138))*0.1
and the one after should be
=(I35-((F15-408)*1.138))*0.1
That's what your INDIRECT formula did. Personally I would use INDEX though:
=(INDEX($I:$I,COLUMN(AH1))-((E15-408)*1.138))*0.1
I just gave that a try and the result is a figure which is totally different to the one It's supposed to be reporting. Are you sure the INDEX is correct?
Thanks
I am quite certain that INDEX($I:$I,column(AH1)) refers to I34, yes.
Many thanks. I'll give it a go.
I just gave it a quick go and it still leaves out the calculation - (AH1))-((E15-408)
Any help?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks