Maybe...

=if(a1<1,"maybe percentage","maybe not")

What happens at 100% = 1?

Alan wrote:

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)

--

Dave Peterson