+ Reply to Thread
Results 1 to 8 of 8

Trying to add .1 to whole row automatically. Please Help!

  1. #1
    Registered User
    Join Date
    05-21-2013
    Location
    MN,USA
    MS-Off Ver
    Excel 2003
    Posts
    5

    Trying to add .1 to whole row automatically. Please Help!

    Hi! I am in desperate need to figuring out how to put a formula into a row (.1 per number into the row automatically). For example:

    So if I have 5 clients
    .1 per client needs to be added per client.
    = .5 per hour

    So, for 3 hours if there was 5 clients...
    3 hrs. x .5 per hour = 1.5
    1.5 + 3 hrs. = 4.5

    Basically, I want for each client that is on the row, I want .1 added to it automatically. For example, if I have 7 clients in C3, .7 should be added to it automatically.

    Please help!
    Thank you!

  2. #2
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: Trying to add .1 to whole row automatically. Please Help!

    a1: # clients
    b1: hours

    c1: =a1*.1+b1
    Last edited by Teethless mama; 05-30-2013 at 09:47 PM.

  3. #3
    Registered User
    Join Date
    05-21-2013
    Location
    MN,USA
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Trying to add .1 to whole row automatically. Please Help!

    This is a daily thing unfortunately, I should have been clearer. (Sorry! -_-) I put a number in A1 and only A1 has to have .1 added to each whole number. (Ex. 5 clients = .5) I want this to be autofilled everytime I put a number in.

  4. #4
    Registered User
    Join Date
    05-21-2013
    Location
    MN,USA
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Trying to add .1 to whole row automatically. Please Help!

    This is what I am currently working on. Highlighted in red is all I care about for now. For each whole number (Example: 5 clients = .5 and 1 client = .1) is what I am trying to do so it adds up with the billable hours and the totals. The main objective is how do I put .1 automatically when I have a another whole number? (Client in this case.)
    Attached Files Attached Files

  5. #5
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,368

    Re: Trying to add .1 to whole row automatically. Please Help!

    Try this =SUMIF($A$6:$A$23;"Clients";B$6:B$26) put in B3, it add up when you input value on Client
    Is this what you mention? Sorry I'm still confused....

  6. #6
    Registered User
    Join Date
    05-21-2013
    Location
    MN,USA
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Trying to add .1 to whole row automatically. Please Help!

    1 client = .1
    5 clients = .5
    10 clients = 1

    For each client is a .1

    Mon. Tues. Thurs. is 3 hours a day
    Only Wed. is 2 hours a day

    Main objective is to get the clients to automatically have the .1 added when entering clients to calculate hours a day for group sessions

    For example, if 5 clients come in on Monday, it would be 3 hours on a Monday

    5 clients x .1 per person = .5 per hour
    then x 3 hrs .5 = 1.5
    take the 1.5 + 3 hours= 4.5 hours

  7. #7
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Trying to add .1 to whole row automatically. Please Help!

    If B3 = clients and B4 = hours
    then you need
    =(1+A3/10)*B4

  8. #8
    Registered User
    Join Date
    05-21-2013
    Location
    MN,USA
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Trying to add .1 to whole row automatically. Please Help!

    these seem like great answers but still not working for me
    Last edited by crazyfool82; 06-04-2013 at 02:30 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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