Excel help

Discussion in 'Mac Apps and Mac App Store' started by rdowns, Dec 19, 2006.

  1. rdowns Suspended

    rdowns

    Joined:
    Jul 11, 2003
    #1
    I need to write a formula to calcualte a fee.

    The fee is 8% of a number.
    The minimum fee is $20
    The maximum fee is $80

    How would I do that?
     
  2. bearbo macrumors 68000

    bearbo

    Joined:
    Jul 20, 2006
    #2
    =IF(A1*0.08>20,IF(A1*0.08<80,A1*0.08,80),20)

    where A1 is your "a number"
     
  3. savar macrumors 68000

    savar

    Joined:
    Jun 6, 2003
    Location:
    District of Columbia
    #3

    if(a1>250,(if(a1<1000,a1*.08,80),20)
     
  4. emw macrumors G4

    emw

    Joined:
    Aug 2, 2004
  5. rdowns thread starter Suspended

    rdowns

    Joined:
    Jul 11, 2003
  6. emw macrumors G4

    emw

    Joined:
    Aug 2, 2004
    #6
    What - you're not going to tell us which one you used? :p
     

Share This Page