Forum

Hello, In my opinion you should go for a non formula solution, makes things far more easier. In attached file I have added three sheets, Pivot, PQ ...

Hello, See if Mynda’s blog about Linear Regression gives you any help in this. Br, Anders

Hello, I find it difficult to follow the logic here, you want to sum something overdue in P column. How do you know if it is overdue when there are...

Hello, This issue is similar to what can happen on a computer also. Go to View and untick to show the grid lines. Does it behave the same when you ...

Hello, Can’t really explain why it behaves like this, but if you round the calculation in column G you get correct result back from your lookup. Bu...

Hello, This is a math excercise. What is 1% of 14800 = 14800 / 100 = 148 What is 0.25% of 148 = 148 * 0.25% = 0.37 How many 0.37 can you h...

Hello, Same happens to me in Excel on iPad.

Hello, Easiest method to reverse calculate percentage is value / percentage * 100. 1.48 / 4 * 100 = 37 37 / 0.25 * 100 = 14 800 Br, Anders

Hello, Just restructure your lookup tables and then it's just ordinary VLOOKUP to get what you want. See attached copy of your file. Br, Anders

Hello, Your latest example corresponds to product 000.000.003 in FBA sheet, where the formula given in my previous post gives profile 10 as result....

Hello, Not really sure I understood you correct Giuseppe, but I give it a try. Check if below formula give correct result in G2. =XLOOKUP(1, (Ta...

Hello, I suppose you are looking for something like burn down and burn up charts. Otherwise I got lots of pages with templates when searching, s...

Hello, A short answer is following formula: =IF(OR(A1<301,AND(A1>=700,A1<1100)),15%,13%) But this is not dynamic in any way. If the ...

Hello, If you can share a file with some sample data, I’m pretty sure we can find a satisfying solution. Br, Anders

Hello, Thank you for your feedback. This is the way the data should be structured, makes it a lot easier to get wanted data from pivot tables and f...