Hello,

I am trying to write an IF formula for my smartsheet that adds the letter A, B, C or D or E to a column pending on a dollar amount listed in another column, but I cannot seem to get the ranges to work right and everything is listed as either A or B.

Current base formula: =IF([Total Assets]@row >= 1000000, "A", IF([Total Assets]@row <= 1000000, "B", IF([Total Assets]@row <= 750000, "C", IF([Total Assets]@row <= 500000, "D", "E"))))

We want the formula to add an "A" if the value is equal to or over $1000000, a "B" if it is less than $1000000, a "B" if it is equal to or over $750000, a "C" if it is between $500000 and less than $750000, a "D" if it is between $250000 and $500000 and an "E" if it is less than $250000.

I cannot seem to get this formula to work correctly for me. Can anyone help me get this functioning the way I desire written above?

Thank you!