IF Statement for a range of numbers

Jessb9187
Jessb9187 ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

Good afternoon,

I am trying to get a cell to auto populate with a specific word if another cell has a specific range of numbers in it. I keep getting an #unparseable but I found this formula in the community and it worked for someone else trying to perform the same thing.

I have 5 tiers of numbers to work from and my formula currently looks like this: 

=IF([Notification Booked Billing Amount]1@row < $1,000.00, "SMB - LOW", IF((Notification Booked Billing Amount]1@row < $3,000.00, "SMB - HIGH", IF([Notification Booked Billing Amount]1@row < $5,000.00, "MID Low", IF([Notification Booked Billing Amount]1@row < $10,000.00, "MID High", "Key Account")))

What am I missing?

Comments