Forum

Hello Thank you for your time my question is solved with VALUE function in helper column I attached solved file

Thanks for your time after see the attached file please read below notes : in the table if column A maked by hand, I don't have any problem...

in the sheet 1 please hide row 15 which is last row. true result is 0 but SUBTOTAL,105 returns -2.00%. I can't understand it. for the main question...

Hello again, In the file in this post I copied column A and B and added new value in each section Thank you very much for your reply

Dear Sir, In the last file that I uploaded the formula is true but it is for maximum drawdown "900$ - 30%" I use it but I need another formula ...

Thank you for your time Qoutation : "In your example, 500 and 25% is based on range A3:A6, considering cells A3=2000 and A6=1500." Its TRUE Expl...

thank you very much can you please advise me "how can i get information to use power query just to use your table to my file"

Hello, I have another problem and I updated the file I have more variables to calculate also include empty cells but dot not consider empty cel...

Sorry for my little explain and thank you very very very much God bless to your life

Thank you very much for your answer your formula is very good to calculate percentage "25%" but it is half of my question , how can I get to for...

Please look at column B & C in this file it can be calculate automated but the result is not true look at please and I'm sure you get my me...

I want average of positive and negative number in column A and also it's need to calculate automatically column B because I have variable data in thou...