Excel Help

Discussion in 'Tech Talk' started by Johnspark, Aug 10, 2007.

  1. Johnspark

    Johnspark Grumpy Fish

    Messages:
    1,906
    Likes Received:
    137
    Joined:
    Dec 16, 2005
    Location:
    Southeastern U.S.
    I need a formula.


    I want to write a formula that will be based on conditions.


    Such as:

    A1 (user specified value) 24% or 30% or 35%


    A2=$100.00

    A3(formula cell) if A1=24% multiply A2 by .17 - if A1=30% multiply A2 by 23% - if A1=35% multiply A2 by 27%

    Does anyone have an idea how to enter this?
     
  2. Johnspark

    Johnspark Grumpy Fish

    Messages:
    1,906
    Likes Received:
    137
    Joined:
    Dec 16, 2005
    Location:
    Southeastern U.S.
    Nevermind I got it.

    =IF(F5=24%,F7*0.17,IF(F5=30%,F7*0.23,IF(F5=35%,F7*0.27)))


    Thanks anyway.:banana: