need help with formula(s)

[_Bigred]

(Excel 2000)

I need to create a formula that does the following:


25¢ per hour added on, if you are under $13.00 (but you could only move to a
maximum of $13.00 per hour).

Example 1:
Current Wage $12.00 add the 25¢ = $12.25 (Get the whole 25¢)

Example 2:
Current Wage $12.98 add the 25¢ = $13.00 (Get only 2¢)

then I need to also have either the same formula or a seperate formula do
the following:

If $13.00 or greater you would add 10¢ per hour.

Is there a easy way to do this, since my excel file contains 5,611 records?

Any help would be greatly appreciate,
_Bigred

 

[Alan]

With the rate payable per hour in A1, 0.25 in B1 and 0.1 in C1,
=IF(A1+B1<13,A1+B1,IF(A1>=13,A1+C1,13))
That way if the enhanced rates change you only need to alter B1 and C1
Regards,
Alan.

 

[CLR]

=IF(A1<12.76,A1+0.25,IF(A1>=13,A1+0.1,13))

Vaya con Dios,
Chuck, CABGx3

 

[_Bigred]

That worked perfectly.

Thanks much Alan,
_Bigred

 

[_Bigred]

Actually Alan's formula worked perfectly.

Your formula wouldn't work properly if a person made $12.98 the formula
would need to add 2¢. etc....

 

[Alan]

Bigred,
Chuck's formula also works perfectly, try it
Alan.

 

[_Bigred]

I'll check it out, maybe I entered it incorrectly.

TIA,
_Bigred

 

[CLR]

Thanks Alan.......

I thought I had checked it thoroughly before I sent it......and was
pondering what to say, but you took care of it nicely............

Vaya con Dios,
Chuck, CABGx3