# Nested Ifs not working

Hey,

I'm trying to create some nested ifs for grid logic.

This works perfectly for one if statement

=IF(LOE@row = "Large", "12", “Empty”)

But once I start to nest, it does not, and I've tried multiple combinations of parens and read the articles, etc, but it keeps saying #UNPARESEABLE"

=IF(LOE@row = "Large", "12", IF(LOE@row = “Small”, "4”, "Empty”))

Where I am trying to go is something like this, but I need above to work first!

=IF(LOE@row = "Extra Large", "20", IF(LOE@row = “Large”, "12", IF(LOE@row = “Medium”, "8", IF(LOE@row = “Small”, "4", IF(LOE@row = “Extra Small”, "1”, "Empty”)))))

(I also tried IF([LOE]@row based on other articles, but Smartsheet just deletes the [] brackets)

What am I doing wrong?

Tags:

• Hi Rebecca,

When you're entering numeric values as results in formulas, you don't need to add it in quotes. It is only needed for strings. Here's the formula you can use.

=IF(LOE@row = "Extra Large", 20, IF(LOE@row = "Large", 12, IF(LOE@row = "Medium", 8, IF(LOE@row = "Small", 4, IF(LOE@row = "Extra Small", 1, "Empty")))))

Thanks,

Aravind

Reach out for any help on licenses, configuration, or training

• Hi Rebecca,

When you're entering numeric values as results in formulas, you don't need to add it in quotes. It is only needed for strings. Here's the formula you can use.

=IF(LOE@row = "Extra Large", 20, IF(LOE@row = "Large", 12, IF(LOE@row = "Medium", 8, IF(LOE@row = "Small", 4, IF(LOE@row = "Extra Small", 1, "Empty")))))

Thanks,

Aravind

Reach out for any help on licenses, configuration, or training

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!