This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I would like to be able to create the column "overview allocation" based on the information in the column "allocation1" and "allocation2". The idea is to know if the overview allocation is X or 50%X and 50% other allocation. Please find the Excel below. Could you, please help me to create the formula?
I believe that the attached workflow should solve your problem. However, just understand that it is not a very dynamic solution meaning that if there are more allocation columns than the 2 you specified, this workflow would no longer work properly and would need to be updated.