Advertise on Bikeforums.net



User Tag List

Results 1 to 4 of 4
  1. #1
    la vache fantôme phantomcow2's Avatar
    Join Date
    Aug 2004
    Location
    NH
    Posts
    6,266
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question about excel formula

    Suppose I have a rule:

    If a number is equal to greater than 10, I want the number multiplied by 3.
    If a number is less than 10, I want the number multiplied by 2.

    Is there a way I can setup a formula in excel such that if I enter a number equal to or greater than 10, it multiplies by 3. And if I enter a number less than 10 in the same cell it automatically multiplies by 2, pursuant to the rule above?
    C://dos
    C://dos.run
    run.dos.run

  2. #2
    GATC
    Join Date
    Jul 2006
    Location
    south Puget Sound
    Posts
    6,620
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    =if(a1<10,a1*2, a1*3 )

  3. #3
    GATC
    Join Date
    Jul 2006
    Location
    south Puget Sound
    Posts
    6,620
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm not paying to dress casually though

  4. #4
    la vache fantôme phantomcow2's Avatar
    Join Date
    Aug 2004
    Location
    NH
    Posts
    6,266
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hahaha, thanks .
    C://dos
    C://dos.run
    run.dos.run

Posting Permissions

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