Is there a way to check if a user enter a percentage or a regular number into
a cell, then apply different formula to it?

Note: user will enter a huge number like 2,345,678, or 22% (of something)