[=IF(I74<=50000,”150″,IF(I74<=100000,”200″,IF(I74<=150000,”250″,IF(I74<=200000,”300″,IF(I74<=250000,”350″,IF(I74<=300000,”400″,IF(I74<=350000,”450″,IF(I74<=400000,”500″,IF(I74<=450000,”550″,IF(I74<=499999,”600″,IF(I74>500000,”report”)))))))))))]
I have this formula in a column in MS Excel, but I could not use the SUM function at the end of the data. Please help me with this.
I was trying to have the sum of the column, but i could not get it.
New contributor
user24664789 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.