Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Posts
    191
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula help (2003)

    Hi all,
    I have a workbook with three columns. Column A contains data selections "Annual", "Quarterly" or "Monthly". Column B contains budget figures in currency format. I what Column C to produce a result which would be Col B divided by 12 if Column A was "Annual", 3 if it was "Quarterly" and 1 if it were "Monthly".
    Can this be easily done?
    Thanks heaps.

    Bill

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula help (2003)

    Does this do what you want?

    =IF(UPPER(A2)="ANNUAL",B2/12, IF(UPPER(A2)="QUARTERLY", B2/3, IF(UPPER(A2)="MONTHLY", B2/1, "")))

  3. #3
    2 Star Lounger
    Join Date
    Mar 2003
    Posts
    191
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula help (2003)

    Sorry. No luck. It just returns a empty cell. Thanks for trying. Any other suggestion?

  4. #4
    2 Star Lounger
    Join Date
    Mar 2003
    Posts
    191
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula help (2003)

    Whoops. No you got it. It wouldn't work the first time because we had spelt ANNUALLY differently. Thanks heaps again.

    Bill

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula help (2003)

    Hmmm...it worked for me....

    I made the assumption in the formula you had headers in row 1 and your data began in row 2. Was your data in cells A2, B2, and C2? Are the words written out "Quarterly", "Annually", and "Monthly" as in your original post?

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula help (2003)

    OK...good to know! It's past my bedtime and I thought maybe that was going to have something to do with it <img src=/S/yawn.gif border=0 alt=yawn width=15 height=15>

  7. #7
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    The Hague, Netherlands
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula help (2003)

    No need to call UPPER three times for IF is not case-sensitive.
    Microsoft MVP - Excel

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula help (2003)

    I didn't know that...thanks for the tip.

Posting Permissions

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