# Help with converting inherited Excel Formula

Options
✭✭✭✭✭

Hello,

I have inherited this formula from an excel sheet that i can trying to get working in Smartsheet however as a novice... i am struggling. Grateful for any support.

=IF(M10<=5,"Low",IF(AND(M10>=6,M10<=11),"Medium",IF(AND(M10>=15,M10<=25),"High",IF(AND(M10=12,K10=4),"High","Medium"))))

Protonspounge

• ✭✭✭✭✭✭
Options

Assuming the cell references relate to named columns i.e. M10 is row 10 in column M and that the formula only calculates within that row.

Changing the cell ref to @row should do the trick as below tested and working

=IF(M@row<=5,"Low",IF(AND(M@row>=6,M@row<=11),"Medium",IF(AND(M@row>=15,M@row<=25),"High",IF(AND(M@row=12,K@row=4),"High","Medium"))))

Save and refresh the sheet once the formula is entered if you get the random unparseable error and that should fix it right up.

Hope that helps

Thanks

Paul

• ✭✭✭✭✭✭
Options

Assuming the cell references relate to named columns i.e. M10 is row 10 in column M and that the formula only calculates within that row.

Changing the cell ref to @row should do the trick as below tested and working

=IF(M@row<=5,"Low",IF(AND(M@row>=6,M@row<=11),"Medium",IF(AND(M@row>=15,M@row<=25),"High",IF(AND(M@row=12,K@row=4),"High","Medium"))))

Save and refresh the sheet once the formula is entered if you get the random unparseable error and that should fix it right up.

Hope that helps

Thanks

Paul

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!