Multiple number formats in Conditional IF statement

Thank you, Rahbee. This defintely helps for a part of the problem.

Any clue as how mutiple number formats could co-exist in a single IF condition?

Regards,
-Laxman