More Formulas...
More Formulas...
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: More Formulas...

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi, I need a single formula to do this please ......

    If A1<6 then C1=D1,

    If A1>=6 but <9 then C1=D1+30%

    If A1>=9 then C1=D1+60%

    Hope that makes sense, it was the easiest way i could think of explaining what i need


    ..oh yeah, no macros allowed


    Thanks for your help as always.

    Anx

    [ This Message was edited by: Anx on 2002-04-15 17:09 ]

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    390
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    In C1 comes:
    =IF(A1<6,D1,IF(A1>=9,D1*1.6,D1*1.3))

    [ This Message was edited by: Albert 1 on 2002-04-15 17:31 ]

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    363
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm assuming that the formula will be in cell C1. Here you go:

    =if(A1<6,D1,if(A1<9,D1*1.3),D1*1.6)
    It's never too late to learn something new.

    Ricky

  4. #4
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How about:

    =IF(A1>=9,1.6,IF(A1>=6,1.3,1))*D1

    a little less typing.

    Jay

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks all

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com