Friday, February 22, 2013

Financial Report in Excel Part-1



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
at
Labels:
Location: Ahmedabad, Gujarat, India

1 comment:

  1. AnonymousFebruary 22, 2013 at 5:20 AM

    Very nice concept. It clear concept to get zero at last position. Share some more stuff

    ReplyDelete

Subscribe to: Post Comments (Atom)

Notification Example

Notification Example This is an example Notification for Android Operating System.. It covers a two notification, one has sound, vibratio...

  • Preference Controls : Android Training
    Preference Control in Android In Android with Shared Preferences we can set controls to build preference screens. 1. Check box Preferenc...
  • Notification Example
    Notification Example This is an example Notification for Android Operating System.. It covers a two notification, one has sound, vibratio...
  • Financial Report in Excel Part-1
    Financial Report in Excel Part-1 With the video demonstration, u can learn how to convert last digit of a given number into zero...