Hello - We have a CSV file with a text string and we need to calculate data from another cell using formulas in several locations of the text string.
This is the text string with the formulas marked in blue.
{"administrator":{"role_price":"=C2*1.15"},"customer":{"role_price":""},"Price_Level_B":{"role_price":"=C2*1.6/1.7*1.15"},"Price_Level_D":{"role_price":"=C2*1.1*1.15"},"Price_Level_F":{"role_price":"=C2*1.6/1.8*1.15"},"staff_discount":{"role_price":"=C2*1.15"},"wholesale":{"role_price":"=C2*1.15"},"wholesale_cod":{"role_price":"=C2*1.15"}}
After some research, it appears we cannot have multiple formulas in a single cell, so is there an alternative way we can achieve the above?
Thank you in advance!
Bookmarks