I have this is in my excel sheet
=IF(C2>=30, "2000", IF(C2>15,"520", IF(C2<=15,"400")))
this works in that it provides a result in the cell.
however, this cell is in a column of which I need a total sum. it does not read this cell??
how can I fix this?