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.
MS_64804 You added a table with just headers. No data to test the formulae you have columns BI to BQ.
Without really knowing what I'm looking at, my initial though is that a formula like below is unnecessarily complicated.
=IF(Table1[@Service]="","",IF(Table1[@Service]<99,0,IF(AND(Table1[@Service]>=99,Table1[@Service]<=99.3),1,IF(AND(Table1[@Service]>=99.31,Table1[@Service]<=99.49),2,IF(AND(Table1[@Service]>=99.5,Table1[@Service]<=99.69),3,IF(AND(Table1[@Service]>=99.7,Table1[@Service]<=99.8),4,IF(AND(Table1[@Service]>=99.81,Table1[@Service]<=100),5,"")))))))You need to provide som example data and explain the end result you are after.
The data is all the way at the end, that's what I was telling you. You can put the data in the table and when you scroll all the way to the end you will see the sum.
Scroll all the way to the end to column BI , the formulas are in there.