Hi, I want to have a simple table for a QSR where a user inputs the amount of sales generated from each third party delivery company and it calculates the actual turnover generated after taking in to account what needs to be be paid to the delivery companies.
So I inputted the following
IFS([Delivery Companies]="Uber Eats",[Deliveries]*0.3*1.15, [Delivery Companies]="Mr D",[Deliveries]*0.225*1.15, [Delivery Companies]="Buzz",[Deliveries]*0.225*1.15)
The [Deliveries] column is where the daily sales amount is inputted and I want to calculate the commission which is the 0.3, 0.225, and 0.225.
The other value, 1.15 is to calculate the VAT on top of that.
I tried to input the value as both a FORMULA and an INITIAL VALUE and while I get no errors in the expression assistant I am just getting a “$0.00” result in that column. Where am I going wrong?