Forum Discussion
Grading System
Hello,
I am doing a grading system for my company and need assistance with the last formula because 2 of the other formulas have "n/a" in them.
7 Replies
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.
MS_64804 So the problem is that you have several grades, some of which ar NA. Then you add them up and you get NA as well. True?
Why not give a score of 0 (zero) in stead of NA(). Alternatively, look into the AGGREGATE function, rather than the regular sum.
If this doesn't make sense at all, perhaps you can upload an example of your workbook with the formulae in it, indicating the problem. Just remove any private and confidential information.
