Need if/andformualbased on multiple conditions

November 5, 2012 at 19:39:26
Specs: Windows XP
I am trying to create an IF/AND formula based on multiple factors but I am getting confused and cannot get the formula to do everything I need it to do. I have only been using the IF/AND formula for 4 months so I am pretty new at what all it can do and have a lot to learn. I need an IF/ANDF formula that states if the date in one cell is greater than the date in another cell and the contents of a third cell is equal to an account number, then use the overhead (OH) rates for FY 2012, otherwise use the overhead (OH) rates for FY 2012.

A1 = December 2011 Account # FY 2011 Rate FY 2012 Rate

1000-000 29.21% 15.54%

1000-100 44.86% 31.34%

1000-600 24.35% 20.21%

Example:

If if D3 (April 2012) is greater than A1 (December 2011) and account number equal 1000-000, then use rate 15.54% or

If D3 (April 2012) is greater than A1 (December 2011) and account number equal 1000-100, then use rate 31.34% or

If D3 (April 2012) is greater than A1 (December 2011) and account number equal 1000-600, then use rate 20.21% or

If D3 (April 2012) is lessthan A1 (December 2012) and account number equal 1000-000, then use rate 29.21% or

If D3 (April 2012) is less than A1 (December 2012) and account number equal 1000-100, then use rate 44.86% or

If D3 (April 2012) is less than A1 (December 2012) and account number equal 1000-600, then use rate 24.35%

Is there a nested IF/AND or IF/OR formula or any formula that will work? My boss is asking for this spreadsheet andI have everything else completed except this piece wich calculate the employees applicable overhead rate based on if a particualr month is greater than or less than the month in a cell and a particular account code

Thanks in advance.


See More: Need if/andformualbased on multiple conditions

Report •


#1
November 5, 2012 at 19:53:24
It's hard to tell where your account numbers are stored. You said that you need to compare the date in D3 to the date in A1, but we don't know where the account numbers are stored.

Please click on the following line and read the instructions on how to post example data in this forum, then repost your data, including Column letters and Row numbers.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
November 5, 2012 at 19:59:39
DerbyDad

For some reason I cannot get the VBA to work to line everything up,

My dates are storeda cross one row of the same workseet

Example, Row D3 - Apr 12, E3 - May 12, F3 - June 12, etc until it get to Dec 12

The account codes (1000-000, 1000-100, 1000-600 and the overhead rates are on a separate worksheet in the same workbook.

Hop this makes sense. Thank you.


Report •

Related Solutions


Ask Question