+ Reply to Thread
Results 1 to 14 of 14

Creating a formula to add 30% to worksheet figures?

  1. 10-10-2008, 07:17 PM #1
    EasyTech
    EasyTech is offline
    Registered User
    Join Date
    10-10-2008
    Location
    MA
    Posts
    7

    Creating a formula to add 30% to worksheet figures?

    Ok guys, im new to the forum and excel. I have a late report due @ work.... I have people who have worked for 4 days to get me numbers i need and they are not right.....

    Anyways I have a spreadsheet with a whole lot of numbers on it... I need to add 30% to each number. What is the easiest way to set this up. Help ASAP would be greatly appreciated. Thank You.
    Last edited by Simon Lloyd; 10-10-2008 at 08:05 PM. Reason: Title changed to reflect content
    Reply With QuoteRegister To Reply
  2. 10-10-2008, 07:48 PM #2
    malnahar
    malnahar is offline
    Forum Contributor
    Join Date
    02-12-2008
    Location
    Doha-Qatar
    MS-Off Ver
    Excel 2007
    Posts
    137
    Hi Easy Tech,

    Welcome to the forum

    Let’s assume that your numbers are in A1:A10; in B1 put this formula =a1*.3+a1, copy this formula down to B10.

    Does this help

    Regards
    Reply With QuoteRegister To Reply
  3. 10-10-2008, 07:51 PM #3
    JamesT1
    JamesT1 is offline
    Forum Contributor
    Join Date
    08-04-2008
    Location
    West Calder, Scotland
    MS-Off Ver
    365
    Posts
    418
    Hi EasyTech


    Welcome to the forum...... the equations are in the second column

    Hope this helps
    Attached Files Attached Files
    Last edited by JamesT1; 10-10-2008 at 07:54 PM.
    Reply With QuoteRegister To Reply
  4. 10-10-2008, 07:58 PM #4
    EasyTech
    EasyTech is offline
    Registered User
    Join Date
    10-10-2008
    Location
    MA
    Posts
    7

    blah

    I have numbers everywhere on this spreadsheet. I'm not sure where or how to put the formula in. They are in column B-M Rows 7-40... In random boxes. I think i may just be better taking a calculator and doing it all seperatly lol.
    Reply With QuoteRegister To Reply
  5. 10-10-2008, 08:00 PM #5
    JamesT1
    JamesT1 is offline
    Forum Contributor
    Join Date
    08-04-2008
    Location
    West Calder, Scotland
    MS-Off Ver
    365
    Posts
    418
    Hi

    Can you post an example of your spreadsheet
    Reply With QuoteRegister To Reply
  6. 10-10-2008, 08:01 PM #6
    EasyTech
    EasyTech is offline
    Registered User
    Join Date
    10-10-2008
    Location
    MA
    Posts
    7
    That does help.. I dont think me being lazy and expecting numbers to calculate themselves was going to work. How do you attach files? i'll show you what im working with.
    Reply With QuoteRegister To Reply
  7. 10-10-2008, 08:04 PM #7
    EasyTech
    EasyTech is offline
    Registered User
    Join Date
    10-10-2008
    Location
    MA
    Posts
    7

    file

    here it is. NM
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 10-10-2008, 08:07 PM #8
    JamesT1
    JamesT1 is offline
    Forum Contributor
    Join Date
    08-04-2008
    Location
    West Calder, Scotland
    MS-Off Ver
    365
    Posts
    418
    Select the add reply button,, above this box select the paperclip icon,,,,, select the 'Browse' button,,,,,,, navigate to your spreadsheet then select the 'Upload' button,,,,, then submit your reply
    Reply With QuoteRegister To Reply
  9. 10-10-2008, 08:07 PM #9
    Simon Lloyd
    Simon Lloyd is offline
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    Title changed to reflect content!

    Easytech, please take a moment to read our forum rules, particularly rule 1 with regards to thread titles!
    Not all forums are the same - seek and you shall find
    Reply With QuoteRegister To Reply
  10. 10-10-2008, 08:09 PM #10
    EasyTech
    EasyTech is offline
    Registered User
    Join Date
    10-10-2008
    Location
    MA
    Posts
    7
    Ouch, just got owned by the admin lol
    Reply With QuoteRegister To Reply
  11. 10-10-2008, 08:19 PM #11
    JamesT1
    JamesT1 is offline
    Forum Contributor
    Join Date
    08-04-2008
    Location
    West Calder, Scotland
    MS-Off Ver
    365
    Posts
    418
    EasyTech

    hope this will help
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  12. 10-10-2008, 08:20 PM #12
    EasyTech
    EasyTech is offline
    Registered User
    Join Date
    10-10-2008
    Location
    MA
    Posts
    7
    Thank you for your patience guys.
    Reply With QuoteRegister To Reply
  13. 10-10-2008, 08:21 PM #13
    EasyTech
    EasyTech is offline
    Registered User
    Join Date
    10-10-2008
    Location
    MA
    Posts
    7
    Wow, how did you learn those moves ? lol I wish i had u at the office ! I need to work on my office skills. I'm only good with publisher.... 1 step at a time i guess right.
    Reply With QuoteRegister To Reply
  14. 10-10-2008, 08:28 PM #14
    JamesT1
    JamesT1 is offline
    Forum Contributor
    Join Date
    08-04-2008
    Location
    West Calder, Scotland
    MS-Off Ver
    365
    Posts
    418
    glad to assist,,,, we all start somewhere
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using Excel to help select Lotto numbers.....
    By farmerTom in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 10-15-2018, 05:09 AM
  2. differencing sets of numbers, multiplying, and summing
    By stocknewb in forum Excel General
    Replies: 12
    Last Post: 09-02-2008, 09:24 PM
  3. Need a solution to edit numbers
    By KarambaStar in forum Excel General
    Replies: 5
    Last Post: 02-14-2008, 12:26 PM
  4. finding "like" part numbers
    By leapyleigh in forum Excel General
    Replies: 5
    Last Post: 09-02-2007, 02:43 PM
  5. Missing numbers
    By patranihar in forum Excel General
    Replies: 2
    Last Post: 05-06-2007, 04:30 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1