Recent content by keanur

Hi @AVK, Thanks for showing the way, I will use this formula

Hi @p45cal tried to plug in the formula, however always has the error notif. Any suggestion? thanks

Hi Excel Ninja, I would like to know, how to split monthly budget to daily budget with dynamics number. I include actual numbers from year 2022 as reference and also the worksheet as a sample. Thank you Keanur

Hi @pecoflyer another lesson to learn, thanks for this. I saw the formula is very simple yet powerful. Cheers

Hi Etaf, Thanks for enlighten myself, i was doing the opposite so that's why the formula did not work well (my reference was from the highest to the small criteria). To answer you: over then 11 means open to sell, and i have added this to my formula. The row if fix. Regards,

Hi All, Good day. I'm recently creating a simple report to show different price setup, in this case i use fruits as my subject. I have done several tests "If Formula" for the last 2 hours and still not find the right setting. Really appreciate if anyone can help me on this, also I would thank...

Hi Vletm, due to the sensitivity of the data, i cant share the original file. i hope you can understand.

Hi Pecoflyer, I actually want to ask that question, i need to understand the logic. Would you be able to breakdown the formula and explained, as you said it might be help me in the future. Thanking you in advance.

Hi Pecoflyer, thank you very much for the help..yes it is working now.

Hi Vletm I tried to use different type of excel but still not give me a proper result. do you mind to elaborate more?

Hi Excel Ninjas, I have a csv file and i converted it to excel, somehow the price column (E1) looks weird as i can't apply sum formula unlikely on column D. i have tried several ways: text to column, smart tag, paste special, value function, replace comma but none give a proper result. May i...

Hi Navic, Thank you so much to share your time and writing the whole explanation, very much appreciated it! i will try to understand the formula one by one and maybe i will come back and ask you further should i need some enlighten. Thank you once again. cheers

Hi Navic, Thank you for this, i can see that the formula is working. do you mind to explain further the formula, what is the function of every formula. Appreciate your feedback on this

Hi Excel Ninjas, I have a table of fruit selling. In this table there are certain categories for the customer to have different price for different booking window. Start from last minute order 1-6 days in advance will get 5% upto 90 days in advance will get 25% of Banana Master Price. I would...

Hi Bosco, thank you for the magic :). yes, i can confirm that the formula working very well and can copy to other tabs! regards, keanur