IF statements

T

T.R.

I have a formula with some "IF" statements that calculates
payroll. Beginning in July everyone gets a raise, so I
associated the months with numbers (6 = July etc), and the
formulas says multiple the number by a certain percent

An ex:

=IF($AC45=1,$AD45*$AD$3*Assume!H$7*$AA45,IF
($AC45=2,$Y45*$AA45*$AF$3*Assume!H$6/$AH$3))*IF
(J$7>=6,$AB45)

My problem is when the cell is less than 6 it returns a
FALSE, what formula would I use to say if its less than 6
then just return the value without the percent increase?

Thanks.
 
A

Anon

T.R. said:
I have a formula with some "IF" statements that calculates
payroll. Beginning in July everyone gets a raise, so I
associated the months with numbers (6 = July etc), and the
formulas says multiple the number by a certain percent

An ex:

=IF($AC45=1,$AD45*$AD$3*Assume!H$7*$AA45,IF
($AC45=2,$Y45*$AA45*$AF$3*Assume!H$6/$AH$3))*IF
(J$7>=6,$AB45)

My problem is when the cell is less than 6 it returns a
FALSE, what formula would I use to say if its less than 6
then just return the value without the percent increase?

Thanks.

I'm not quite sure that I understand fully, but could you put ",1" just
before the final closing bracket?

=IF($AC45=1,$AD45*$AD$3*Assume!H$7*$AA45,IF
($AC45=2,$Y45*$AA45*$AF$3*Assume!H$6/$AH$3))*IF
(J$7>=6,$AB45,1)
 
D

Don Guillett

I don't quite understand the inconsistency of your formula. 1st it is
looking at ac45 and later at j7???
It multiplies by ad45 or y45. Looks like a strange table.

Maybe you could give more exact details for comments

or
try something like this or use a vlookup table
=CHOOSE(MONTH(NOW()),1,2,3,4,5,6,7,8,9,10,11,12)
change the 1,2,3,etc to your values for each month
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple if statements 5
IF Statement on multiple levels 6
average 1
Excel export to Access - Run-time error 1004 6
Formula required. 22
blank cell instead of x 2
sumproduct multiplication 6
Excel Sumproduct 7

Top