If Statement

  • Thread starter Thread starter KellyH
  • Start date Start date
K

KellyH

I have to create a formula that I can't seem to figure
out. Here is the specs:

Column A - Date of hire
Column B - Name
Column C - Position
Column D - Current Rate of pay
Column E - Grade
Column F - Trainee Rate
Column G - Min rate
Column H - Max rate

The result we want is:

If they have worked for us more than 3 months and the
current rate of pay is less than the min rate, then
multiply the min rate by 101% for each 12 months of date
of hire.

Can anyone please help?

Thank you.

Kelly
 
OK provided that column I is where you will put your
result...
Copy and paste and see if this works. (Note that row 2 and
on should have all the "Data" in there...Also make sure
that you format column I to "General" after you put
formual in there.

Try this and let me know if it works...Paste on cell 'I2'

=IF(AND(TODAY()-A2>90,D2<G2),SUM(SUM(SUM(ROUNDDOWN(SUM(SUM
(TODAY()-A2)/360),0)*0.01)+100%)*G2),0)
 
WOW!!! I got parts of it, but I never would have figured
out all the sums. I knew I needed an Excel guru for
this. Thank you.
 
Back
Top