My problem :
Let, Cell K3 contains a number : 568124
Now, if the right most digit is <5, then I am to use Rounddown(K3,-1) , but if the right most digit is >=5, then I am to use Roundup(K3,-1)
What will be the Excel formula containing both the conditions i.e. " < " and " >= "
Awaiting your kind reply.