+ Reply to Thread
Results 1 to 3 of 3

formula to calcualte number based on several factors

  1. #1
    Registered User
    Join Date
    01-20-2013
    Location
    new york
    MS-Off Ver
    Excel 2003
    Posts
    7

    formula to calcualte number based on several factors

    Hi,

    I am sort of new to excel and not so great with using the if and then function so any help would be appreciated.

    looking for a formula to do this:

    if the number(x) is less than 4 then do 15 + (x*7.25), if (x) is larger than 4 but less than 8 then 15 + (x*6), if (x) is larger than 8 but less than 14 then 15 + (x*4) and if (x) is larger than 14 then 15 + (x*3)



    thank you

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,250

    Re: formula to calcualte number based on several factors

    =if(x<4,(15+x*7.25),if(and(x>4,x<8),15+(x*6),if(and(x>8,x<14),15+(x*4),15+(x*3))))

    Try the above
    Alan


    Have you debugged your code?
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    01-20-2013
    Location
    new york
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: formula to calcualte number based on several factors

    not to be a pain but i just remembered the last part :

    i would need this formula to be ale to add 30 to the end result if the cell contained a number with 07 in it

    example:

    column a column b column c column d
    11111 22222 5 50
    07222 22222 5 should be 80

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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