Aug 19 2019 01:02 PM
Aug 19 2019 01:32 PM - edited Aug 19 2019 02:44 PM
I hope your prices are numbers, not texts. The formula could be
=RIGHT(ROUND(B2,2)*100)+0=4
if B2 is top left cell of the prices range (without headers)
Aug 19 2019 01:58 PM
Aug 19 2019 02:43 PM