+ Reply to Thread
Results 1 to 3 of 3

Thread: simple calulation

  1. #1
    Registered User
    Join Date
    12-12-2011
    Location
    Essex
    MS-Off Ver
    Excel 2010
    Posts
    19

    simple calulation

    A1 cell has: 10/10

    Now, with what formula I can find the value of division in B1 ( here 1.0)

    Of course I can use = and type the 10/10, but I do not want to type as I have many of them so some function may be?
    I know it should be very simple but I just cant get to find the solution.

    I tried B1 =value(concatenate("=",A1)) but it doesn't work.
    Last edited by parekhharsh_j; 02-07-2012 at 06:08 PM.

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2007
    Posts
    10,057

    Re: simple calulation

    Try

    =("0 "&A1)+0
    Audere est facere

  3. #3
    Registered User
    Join Date
    12-12-2011
    Location
    Essex
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: simple calulation

    Quote Originally Posted by daddylonglegs View Post
    Try

    =("0 "&A1)+0
    Cheers! See simple.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0