Hi,

I wonder if someone could tell me how to condense this?

=IF(X6=60,"30",IF(X6=90,"45",IF(X6=120,"60",IF(X6=150,"75",IF(X6=180,"90",IF(X6=210,"105",IF(X6=240,"120",IF(X6=270,"112.50",IF(X6=300,"125",IF(X6=330,"137.50",IF(X6=360,"150"),IF(X6=390,"162.5",IF(X6=420,"175",IF(X5=450,"187.50"))))))))))))))

When I put this into Excel 2010, it tells me there are too many nested functions, but I don't know how else to get the same result?

Thanks in advance