if statement

[_Bigred]

Hello All,

Using Excel 2000

I have a range of base hourly rates (u8:u5611)

I want to do the following:

Example:

1) =(u8)*.0076+(u8) (this will give a base hourly value after percentage
increase.)
example: ($12.740)*.0076+(12.740) would equal $12.837

2) If the final calculation is LESS THEN 13.00, add a maximum of 25¢ (up to
a max of $13.00 base hourly rate), and have a cell that would show how much
was actually given to achieve the max $13.00 ??

Does anyone know how I can accomplish this??

TIA,
_Bigred

 

[Ecco]

Hi,

Try this:

=IF((1+0,0076)*U8<13;IF((1+0,0076)*U8<12,75;(1+0,0076)
*U8+0,25;13);(1+0,0076)*U8)

Ecco

 

[J.E. McGimpsey]

One way:

=MAX(MIN(13-U8*1.0076,0.25),0)