1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Help With another formula

Discussion in 'Business Applications' started by quiff, Feb 20, 2015.

Thread Status:
Not open for further replies.
Advertisement
  1. quiff

    quiff Thread Starter

    Joined:
    Jan 28, 2015
    Messages:
    12
    Hi,


    Could you please help with this formula:


    A1 4900
    A2 4900


    =(A1*2+A2)/450+IF(A1>4800,6,IF(A1>2400,4,IF(A1>0,2,0+(IF(A2>4800,6,IF(A2>2400,4,IF(A2>0,2,0)))))))


    Should be 44.6667


    But I get 38.6667.


    Cant get the last bit of the formula to work.
     
  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    HI, I suggest you split it into different cells.
    The answer you get is correct in that sense that once the first IF(A1>4800 is TRUE it adds 6 and that is 38,6667
    I tried some other things but I only get 56,6667 so I cannot understand where you expect the 44,6667

    =((A1*2+A2)/450)+IF(A1>4800,6,)+IF(A1>2400,4,)+IF(A1>0,2,)+IF(A2>4800,6,)+IF(A2>2400,4,)+IF(A2>0,2,0)
     
  3. quiff

    quiff Thread Starter

    Joined:
    Jan 28, 2015
    Messages:
    12
    Hi,


    Yeah I understand that the formula works as it should, but I want it to also consider the other if relating to cell A2 then add the appropriate number.


    So the first bit of the equation works fine but fine. Then consider the ifs for cell A1 which it does. But then it stops and does not consider adding another 6 regarding cell A2.


    Ideally would prefer to keep it to one cell, so if you have any ideas would appreciate.


    Regards
     
  4. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    You should break up the formula into separate sections
    Maybe like this, I don't know, you will have to test
    =(A1*2+A2)/450)+IF(A1>4800,6,0) + IF(A1>2400,4,0) + IF(A1>0,2,0) + IF(A2>4800,6,0) + IF(A2>2400,4,0) +IF(A2>0,2,0)
    Let me know if it helps some
     
  5. Pedro15

    Pedro15

    Joined:
    Oct 5, 2008
    Messages:
    386
    More than one however it works

    C1 =IF(A1>4800,6,IF(A1>2400,4,IF(A1>0,2,0))) gives 6
    C2 =(IF(A2>4800,6,IF(A2>2400,4,IF(A2>0,2,0))))gives 6
    C3 =(A1*2+A2)/450 gives 32.66667
    TOTAL 44.66667

    Pedro
     
  6. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    Have you placed this in one formula?

    =IF(A1>4800,6,IF(A1>2400,4,IF(A1>0,2,0))) + (IF(A2>4800,6,IF(A2>2400,4,IF(A2>0,2,0)))) + ((A1*2+A2)/450)
     
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1143467

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice