1. Welcome to PlowSite. Notice a fresh look and new features? It’s now easier to share photos and videos, find popular topics fast, and enjoy expanded user profiles. If you have any questions, click HELP at the top or bottom of any page, or send an email to help@plowsite.com. We welcome your feedback.

    Dismiss Notice

Does anyone here an Excel expert?

Discussion in 'Business Fundamentals' started by mbdbiz, Aug 9, 2006.

  1. mbdbiz

    mbdbiz Junior Member
    from yahoo
    Messages: 1

    Hello,

    I was wondering if anyone can assist me with a formula for Excel. This is what I need:

    C19 is where you enter the inches
    C20 adds the charge

    The formula to go into C20 needs to be this:

    If the number in C19 is 01" through 12" is entered, add $75. If 13" thorugh 24" is entered, add $175, if 25" through 36" is entered, then add $275, otherwise (or anything else), enter $0 to C20.

    Is this even possible?.:confused: ... I would really appreciate your help.

    Bella:)
     
  2. Gicon

    Gicon Senior Member
    from MA
    Messages: 989

    very very simple. easier explained over the phone. email me your phone # and what you have so far and I will talk you through if youd like.

    GGicas@APerfectLimo.com
     
  3. Mick

    Mick PlowSite.com Veteran
    from Maine
    Messages: 5,546

  4. Rob

    Rob PlowSite.com Veteran
    Messages: 306

    Here's a way to do it using nested If's.
    FYI - Your formula allows 12.5 to fall through the cracks. as well as 24.5 etc.


    =IF(AND(C19>=1,C19<=12),75,IF(AND(C19>=13,C19<=24),175,IF(AND(C19>=25,C19<=36),275,0)))


    HTH
     
  5. norrod

    norrod Senior Member
    Messages: 113

    Since your range increments are equal 1-12,13-24,25-36 you could reduce this formula to ...

    =IF(OR(C19<1,C19>36),0,75+100*(INT((C19-1)/12)))

    This will take care of the fractional increments that fall throught the nested IF function.



    Not sure why you capped at 36" but if you wanded this formula to keep adding 100 for every 12" lift, you could use this formula


    =IF(C19<1,0,75+100*(INT((C19-1)/12)))
    .
    hth