Results 1 to 9 of 9

Help required with multiple formula

Threaded View

  1. #1
    Registered User
    Join Date
    06-26-2015
    Location
    IOM, UK
    MS-Off Ver
    Microsoft 365
    Posts
    31

    Help required with multiple formula

    Hello, would anyone be able to kindly help with a multiple formula?

    I would like to calculate a value with a number of results then to be added together for one total.

    For example: cell value = 123 and one total calculation to be worked out with the following data:

    01-10 x 2.00 = 20.00
    11-20 x 1.95 = 19.50
    21-30 x 1.90 = 19.00
    31-40 x 1.85 = 18.50
    41-50 x 1.80 = 18.00
    51-60 x 1.75 = 17.50
    61-70 x 1.70 = 17.00
    71-100 x 1.65 = 49.50
    100+ x 1.50 = 34.50

    Result would be 213.50

    Can this be done? I would be grateful for any tips, thanks :-)
    Last edited by voniom; 06-26-2015 at 06:21 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. multiple conditions required for formula
    By REDJESS5 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-16-2013, 02:08 PM
  2. IF function - multiple formula required
    By mikejackson in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-15-2013, 09:04 AM
  3. IF formula help required for multiple combinations
    By topnotch in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-21-2012, 02:00 AM
  4. Formula required with multiple conditions
    By bakshi.ishan in forum Excel General
    Replies: 3
    Last Post: 10-07-2011, 12:44 PM

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