Search results

Hello, As a newcomer to powerpivot I'm very excited on using this great tool and I have already built what I think is a pretty complex model. However, I'm not getting the results I expected and I was wondering if there was a way to audit the model by going step by step and seeing what the...

Very nice, I had no idea you could do this.

Hi, INDEX syntex is INDEX(array, row_num, [column_num]) while your array consists of a single column. Your data is not arranged in the right form to utilize this formula with multiple conditions. Attached is my suggestion for a solution. Oren

I think you are right. Just to keep a good thing going (let me know when you've had enough :DD) i put in C10 =5%+1% and it still rounded up. Since neither 5% or 1% give an incorrect result on their own, it means that specifically the aggregate of 5% and 1% is the problem.

Hi Luke, Thanks for your response, I will definitely look into these links BUT... note that even if you just put 5% as a value in C9 (disabling the aggregated errors) the error occurs. Anyways, unless anyone feels like digging deeper into this issue I think we have dug deep enough. Thank you...

How do we summon the NINJAS? :cool:

This is very odd. I thought so too so I checked the values and they were identical (as I mentioned I got TRUE when checking if one equals the other). Also, I checked the effect of rounding up to the 200th decimal and they were all equal to 6%. I can't understand why your solution worked...

Thanks Asheesh. Any chance that you have a clue why this occurred in the first place?

Hi Asheesh, In the attached file you'll find that when the discount (F4) is 6% the result in F5 returns the total discount that correlates with a 5% discount, but for any other figure it returns the correct result. Thank you, Oren

Hello, I have a list of numbers (specifically 1%-10% in whole numbers) arranged in ascending order and I wan't the find in what place is a certain % that I'm looking for. It all works fine except for when I look for 6%, when I get the result for 5% (?!). I checked this both with LOOKUP and...

Hi suhailsheriff, Although I think many people use vlookups way to much for unnecessary things, I believe this is a great problem where vlookup's power is usefull. Since I am an advocate of using assumption cells, I suggest you make a table with the values of quantities and prices. (I'm...