Imagine A1 is a cell that I put numbers in and A2 is a cell that will automatically give the vaule of A1 divided by 5.

=A1/5

But when I enter a number to A1 with a greater than symbol (>) or a less than symbol (<) such as >15, A2 gives #VALUE! instead of >3. Is there a way to code this please?

CodePudding user response：

=IF(N(A1),A1/5,LEFT(A1)&MID(A1,2,99)/5)