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.
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.