okay...so i tried changig the format in the Date of termination, instead of
Terminated, Y or N, I put 0 if not, and a date (numerical) if yes. still
can't make it work. I think I have too many ifs...it keeps saying "to many
arguments", but thought we could use 7?? help, please?
conditions again:
employee must not be terminated on 12/31/04 (now column D), be 21 (DOB
column B), worked 1000 hrs (column E), be employed for one year (date of hire
is column C) and then up to 90000 is a profit share match of 3%, plus 8.7% of
total compensation. no share over 200000 of compensation.
I changed my formerly posted formula (which did not work) to numerical for
date of termination, and used Ceiling to try to force the 200000 limit. I
have tried adding commas, removing commas, adding/removing
parentheses...help, please! thanks.
--
barbarat


"barbarat" wrote:

got it...that is going to come in really handy for spreadsheets in the
future. I had an IF statement a mile long, and it would not work!
so, what if i wanted to do a similar calc; a profit sharing based on 3% of
compensation up to 90,000 plus 8.7% of all compensation? no contribution is
allocated above $200000, but there are really no employees at that level,
anyway.
On 12/31/04 they must be 21 yrs old, have worked 1000 hrs for that year and
still be employed with the company .
would something like this work: hrs worked is column J, and terminated Y/N
is K:

=IF(DATEDIF(B1,"12/31/2004","y")<21,0,ANDIF(J1=1000),0,IF(G1=<90000,(G1 *.03+G1*.087)OR(IF(G190000,90000*.03+G1*.087)AND( IFG1=2000000,(90000*.03+200000*.087),0)))

please...no laughing. i would love to find out where in this formula i've
gone wrong. thanks!
--
barbarat


" wrote:

"barbarat" wrote:
Hello again...yes, I think I understand it.

Great.

The INT is for rounding, right?

Well, for truncating. It will match $1 to $1 through $1.99.
If you want to round (match $2 to $1.50 through $2.49),
change INT(...) to ROUND(...,0). If you want to match $2
to $1.01 through $2 -- i.e, to any dollar or part thereof --
use ROUNDUP(...,0) or CEILING(...,1).