1. ## 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. ## 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. ## Re: Formula help (2003)

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

4. ## 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. ## 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. ## 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. ## Re: Formula help (2003)

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

8. ## 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
•