If Formula help

TWM

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!

Kelly P.

@TWM

Try this:

=IF([Total Assets]@row >= 1000000, "A", IF([Total Assets]@row >= 750000, "B", IF([Total Assets]@row >= 500000, "C", IF([Total Assets]@row >= 250000, "D", "E"))))

Hope this helps!

Kelly P.

@TWM

Try this:

=IF([Total Assets]@row >= 1000000, "A", IF([Total Assets]@row >= 750000, "B", IF([Total Assets]@row >= 500000, "C", IF([Total Assets]@row >= 250000, "D", "E"))))

Hope this helps!

TWM

Thank you so much!!!!

Kelly P.

@TWM Happy to help! 😊

Matt Johnson

Hi @Kelly P.

I just wanted to put this out there too. I copy and pasted your question into the AI create a formula feature just to see what it would do. The formula came out slightly different but with the same end result.

@Alison Clancy #aiusecase

Kelly P.

@Matt Johnson That's interesting; thank you for sharing! With a column name of "Total Assets", I assumed it to hold numbers, but adding the value function is a good safeguard.