DOWNLOAD: Best tool to repair Windows problems & optimize system performance | Best driver update software for your PC
 
Results 1 to 10 of 10

Thread: Excel gurus in here ? Required for a forumula !

  1. #1
    roraniel's Avatar
    roraniel is offline Gold Member
    Join Date
    Oct 2008
    Location
    Pinehurst, NC
    Posts
    860

    Default Excel gurus in here ? Required for a forumula !

    I am trying to write a formula that essentially says the following but I am struggling.

    Cell A2 = 0 if A1 = less than 20000, 200 if Cell A1 = between 20000 & 24999.99, 300 if Cell A1 = between 25000 & 29999.99, 500 if A1 = 30000 & Over

    Can a guru write it for me?


  2. #2
    HappyAndyK's Avatar
    HappyAndyK is offline Site Administrator
    Join Date
    Jun 2008
    Posts
    7,572

    Default

    An MVP collegue of mine, Tushar says :

    The formula for A2 is

    =IF(A1<20000,0,IF(A1<25000,200,IF(A1<30000,300,500 )))

    Hope it helps.

  3. #3
    roraniel's Avatar
    roraniel is offline Gold Member
    Join Date
    Oct 2008
    Location
    Pinehurst, NC
    Posts
    860

    Default

    Works perfect!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

  4. #4
    NinethSense is offline Microsoft MVP
    Join Date
    Jul 2008
    Posts
    2

    Default

    Nice to hear it is working already.

    I am late. Next time...

    Praveen, MVP

  5. #5
    HappyAndyK's Avatar
    HappyAndyK is offline Site Administrator
    Join Date
    Jun 2008
    Posts
    7,572

    Default

    Thanks for being here Praveen runs NinethSense, a tech blog.

  6. #6
    seti is offline Member
    Join Date
    Nov 2008
    Posts
    1,923

    Default

    didn't understand a word of it, and i'm going to have to learn excel shortly. Come back database all is forgiven. surely there has got to be an easy way to work things out, like lenght of words, numerial information etc

  7. #7
    Corrine's Avatar
    Corrine is offline Gold Member
    Join Date
    Jan 2009
    Location
    Upstate NY
    Posts
    961

  8. #8
    seti is offline Member
    Join Date
    Nov 2008
    Posts
    1,923

    Default

    Quote Originally Posted by Corrine View Post
    Thanks Corrine I'll take a look at them on Monday

  9. #9
    JonPaulOnLine's Avatar
    JonPaulOnLine is offline Windows Enthusiast
    Join Date
    Feb 2009
    Location
    PhiladelphiaPennsylvaniaUSA
    Posts
    64

    Default

    The Spreadsheet Page - Excel Tips


    Is a great web site on excel and Mr Spreadsheets published books are great

  10. #10
    tweakwindows's Avatar
    tweakwindows is offline Microsoft MVP
    Join Date
    Jul 2008
    Location
    intowindows.com
    Posts
    1,285

    Default

    ^ Thanks for the link. I am new to MS office, especially for Excel. Need to work on it.

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22