Hi Philip, The links you sent me helped me to create the list successfully to the excel sheet I attached here which i simplified, although when I t...
Hi Velouria, Thank you very much the help, i’ll change all the functions from IFS() to IF(). 😀 Greetings, Stefi
Hi Velouria, I have tried to use IF() instead of IFS() but it keeps telling me that i add too many arguments, and it seems like only IFS() wor...
Hello Velouria and Anders, He said that the error appears in all cells, i think the problem might be in the function IFS(), since i have used it in...
Hi Sunny, Thank you for your reply, glad to know there is no way this could work, i'll try to come up with a new idea 🙂 Greetings, Stefi
Hi Phil, Thank you for your reply, that is the reason i have had a problem to find the right function for that, i don't even know if it is possible...
Hi Philip and Sunny, Thank you so much for your replies and taking the time to help me, both answers are great, i used Sunny's version though,...
I just noticed that in my first post, i was referring to an E1 cell that wasn't used in my attached excel file. Sorry for that, the second one should ...
Hello Philip and Sunny, Thank you for your replies. I have attached a new version of the excel. I have not used a formula in B column, that's why a...
Hi Sunny, Thank you so much for your reply and help, it works perfectly, just had to insert the equations inside the IF function so that it co...