+ Reply to Thread
Results 1 to 3 of 3

Adding Numbers beween spacing

  1. #1
    Registered User
    Join Date
    08-04-2009
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    15

    Adding Numbers beween spacing

    Wow great Title I tell you, hello again Excel experts I know this will come to you very easy I know it, OK here it is...,

    I got a number, OK lets make it every even "5","10", "15" est and i add another one beside it to be added 0.01 every "5" times, so ok i'll make it a bit better some how,
    (A1)
    lv 1
    =1
    lv 2
    =2
    lv 3
    =3
    lv 4
    =4
    lv 5---(A2)----(A3)
    =5 + 0.01 = 5.01

    (A1)
    lv 6.01
    =6
    lv 7.01
    =7
    lv 8.01
    =8
    lv 9.01
    =9
    lv 10--------(A2)------(A3)
    =10.01 + 0.01 = 10.02 est.

    I don't wanna make it hard, if you can try, if not its not a problem I can just do it manually. this was frustrating for me, any help will be greatly appreciated

    um I had one idea that did and one that did not work, 1. to do it manually or 2. (that did not work) us "=IF function"
    Last edited by Side.Order; 11-07-2009 at 05:00 AM. Reason: added more text

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,601

    Re: Adding Numbers beween spacing

    Try this:

    calculate%20cell(1).xls

  3. #3
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    Re: Adding Numbers beween spacing

    Hi,

    Why don't you start by Data Text to Columns ... to clean up your data ...

    HTH

+ 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.6.0 RC 1