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 have attached an excel file which contains of 12 dishes and the total, I have calculated the total by multiplying the quantity of each dish by its price. But I have one problem, dish 12 its price change. So, if the customer ordered only dish 12 the price is 210 and if the customer ordered any dish with dish 12 the price of dish 12 will be 157.5. What I should edit in the formula to achieve this condition?
@Feras95p I would just make a small change to your formula. Instead of only multiplying by 210 all the time, you will want to use an if statement to first check if all of the other dishes are 0 and if so, then use 210. If any of the other fields have a value other than 0, use 157.5. Something sort of like: