Results 1 to 17 of 17

Calculate the amount (£) using a formula

Threaded View

  1. #1
    Registered User
    Join Date
    04-09-2020
    Location
    Waterlooville
    MS-Off Ver
    2016
    Posts
    8

    Calculate the amount (£) using a formula

    Good morning everyone,

    I am new to this forum and I require some help, if possible. There is probablly a very simple solution to my problem but is well above my level of competence. I do appologse if this is not a great challenge to you guys, I know you like a challenge!

    I have started with a new company working as a self employed member of staff and therefore need to devise my own timesheet.

    I have put together a spreadsheet and need to create a a number of different formulae in order to remove human error.

    I have attached an extract of my excel worksheet which will hopefully help. Basically if I enter the number 4 in B3 I would like it to multiplie by the amount in B2 and totals the amount of the entire row in D3 and column in B7. I would need to do this for each cell in all columns and rows in my worksheet




    Any help you can give to me would be fantastic guys.

    Here's hopefull

    Gordon
    Attached Images Attached Images
    Last edited by gbleslie029; 04-09-2020 at 06:11 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 05-08-2019, 02:47 PM
  2. Formula to calculate Amount Paid and Amount Past Due
    By TinaAlldredge in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2016, 09:19 AM
  3. [SOLVED] Calculate Projected Annual amount from Dollar value (Amount) and varying time intervals
    By old dawg in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-16-2016, 07:29 PM
  4. Replies: 2
    Last Post: 11-21-2014, 09:35 AM
  5. [SOLVED] Calculate dollar amount paid if between a to and from amount
    By oxicottin in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-21-2012, 08:01 PM
  6. [SOLVED] How can I calculate amount of time left based on amount spent?
    By KLD in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-23-2006, 11:25 AM
  7. How do I calculate Amount of Sales Tax from Total Amount?
    By MikeS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-26-2005, 04:06 PM

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