Results 1 to 8 of 8

Calculate Figure Based off 3 Values : Complex Formula?

Threaded View

  1. #1
    Registered User
    Join Date
    03-08-2012
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    6

    Calculate Figure Based off 3 Values : Complex Formula?

    Good morning!

    I'm trying to create a formula using 3 values. All of the values are between 1 and 100. For the purposes of this we'll call the values E, I and A and the value we want to calculate C. I'm trying to write a "simple" formula to do this, but I'm struggling a bit. The logic for the result is:

    C= (Ix8)+(Ax4)
    C= round (C/4)

    If (C<250) then C=round ((C/250)x100)
    If (C>250) then C=round ((250/C)x100)
    If (C=250) then C= 100

    If (E<11) then C=round (C-(C/10))
    If (E<21) then C=round (C-(C/10))
    If (E<31) then C=round (C-(C/10))

    I'm sure the logic in this calculation can be simplified, and the E<11/E<21/E<31 calculation is performed 3 times, so if the value of E is 5 then it's less than 11, less than 21 and less than 31 so is subjected to 3 calcuations of C=round (C-(C/10)).

    Sorry for a smelly one on a Sunday morning!
    Last edited by Rimberaud; 10-05-2014 at 06:42 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate One Value Based on a Formula for Three Other Values
    By SpeakingPeace in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-10-2014, 07:14 PM
  2. Complex formula to calculate hrs per month
    By maggi259 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-30-2014, 08:13 AM
  3. Complex Excel Formula Required for Obtaining Values based on Column & Row
    By adeel726 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2013, 04:36 PM
  4. [SOLVED] Multiple Condition Formula to calculate a final figure
    By Graham Taylor in forum Excel General
    Replies: 9
    Last Post: 07-12-2012, 07:46 AM
  5. Calculate new figure based upon % reduction table
    By halfpint123 in forum Excel General
    Replies: 4
    Last Post: 06-14-2012, 09:08 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1