hi all,
i am facing a problem here.
i hv a column "O" which its format cells is number with decimal places is 2
when i click a command button, i want to have another value in column "P"
Below is my coding:
![]()
Please Login or Register to view this content.
but my problem is when my value in column "O" is "35" the the output come out in column "P" is 3.5, the answer should be 10,
it seems like cannot check the value which is more than 10 and ignore the decimal in column "O".
Can someone please help me. thanks.
Bookmarks