Financial Report in Excel Part-1
With the video demonstration, u can learn how to convert last digit of a given number into zero. With the combination of If Function, Value Function, Right Function, Ceiling Function and Floor Function, result generated.
=If (Value(Right(Reference,1))>=5, Ceiling(Reference,10), Floor(Reference,10) )
above combination used to generate the answer
