formula text in cell instead of being calculated

Hi,

Upload the workbook so that we can take a look. Pictures of workbooks don't really help. We like to see the problem in context.

Regards

Hi,

Can you give some examples as to what you're trying to achieve since it's not immedliately obvious - to me at least. State what your input values are and what results you expect to see - and where, - and importantly why.

In C24 =INDEX(LookupData!$C:$C,$C$24-1) probably gives you what you want but I can't help thinking there is a more elegant way of achieving what you want perhaps with a more structured layout.

Regards

Richard,

first of all, there is a new file there. the first one did not have all the descriptors in the right places on the first sheet. so you might want to download again.

I'm an accountant so it's hard to tell you what I'm doing. I want 3 things: the tax rate to match to the table I have on sheet 2, the mandatory tax formula to work correctly, and the "ceiling" number to match.

do you know much about tax? The only inputs are: Taxable Income, and Filing Status. As you can see from the file, Income in 0, and the "My Row" formula gives me row #5, which of course yields the following results in the other formulas:

Rate: 10%
Mandatory: 0 (this is right, but the formula is still looking at the wrong line)
Ceiling: 8375

and of course, if the "My Row" formula was working correctly, the results should be:


Rate: 0%
Mandatory: 0 from line 4, NOT 5
Ceiling: 0

Does all of that make sense? The above examples I gave as references are using these inputs on the first sheet:

Filing Status: 1
Taxable Income: 0

If those numbers are not already there when you download it again, change them and you'll see what I'm referring to.

As far as there being a more elegant way, YES, there is, as the guy that suggested this way also suggested a more efficient way before that....but then again, I hate Excel, so the more info I have the better. The more efficient things are, the more complex they are, and the more I don't want to try and update it because I don't have any expertise in Excel. Hence, he drew this simple picture for me that I implemented (and I didn't even ask for).

Thanks, sir!

Hi,

Don't despair, I'm an accountant too, or was in my previous existence before I retired, so I do know just a little bit about tax

I'd also take issue with your thoughts that the more efficient something is the more complex. I'd argue the complete opposite. But then I've been dealing with spreadsheets since the very first Viscalc in 1979 on the very first Apple II


There was a typo in my last post. I should have referred to C19 & C20. So to repeat

in C19
=INDEX(LookupData!$C:$C,$C$24-1)
in C20
=INDEX(LookupData!$D:$D,$C$24-1)

Regards