Forum Discussion
Grading System
MS_64804 That's a bit abstract. Would be helpful if you could show the formulae.
Riny_van_Eekelen , you are right. It's a bit complicated. So it's hard for me to explain.
But the company is a delivery company and the spreedsheet is to grade my drivers.
So I have a column for driver, driver number, stops, miles, service, complaints, disputes/misdeliveries, pickup/compliance, safey and total.
So far, I have a formula for all except stops, miles and total. I would like to add all the formulas together in the total but 3 of my formulas have n/a in it. Like if a driver 1 complaint "NA" he total will then be "NA" .If the driver do not have any complaints then I would like to sum all the columns up in the total.
=IFS(Table1[@Complaints]>=1,NA(),Table1[@Complaints]="","") - THAT IS THE FORMULA FOR COMPLAINTS
The others are similar with NA.