Formula Syntax Help - Identifying suffix on number.

Shawn Church

I have a sheet tracking orders. Each order has multiple order lines (each item on an order has a separate line with a decimal suffix). I would like to identify each primary order line (order line ending with ".0" but I'm struggling with the formula. I currently have this keyed as a formula =if(Order Line1,right([Line]1,0)"Primary". "") Obviously this is not correct. Can someone help me figure out the correct syntax to return "Primary" in my helper column?

Shawn Church

Perfect! Simple is always better.

Paul McGuinness

Hi @Shawn Church

This formula works, treating the decimal as a decimal simply comparing the cells gives the desired result, as anything with other than a 0 doesn't numerically match.

=IF([Order#]@row = Line@row, "Primary", "Not Primary")

Hope this helps.

Paul

Shawn Church

Perfect! Simple is always better.