Formula???

[mermar]

I am creating a self-adding absentee calendar for employees. I am having a problem with a formula; =SUMIF((I7>(TODAY))(Y26*M$8)). This means that if the date entered in I7 is greater then today, vacation should accrue for hours worked times rate.

 

[T. Valko]

I am creating a self-adding absentee calendar for employees. I am having a problem with a formula; =SUMIF((I7>(TODAY))(Y26*M$8)). This means that if the date entered in I7 is greater then today, vacation should accrue for hours worked times rate.

Maybe this...

=(I7>TODAY())*(Y26*M$8)

 

[Michael M]

Why are you using a SUMIF, wouldn't a simple IF do

=IF(I7>TODAY(),Y26*M$8,"")

 

[mermar]

Yes the =IF would be easier. However I did find that my error lies with the fact the I7 will never be greater then today, since I7 represents the employees 90 days waiting period. So I tried, =IF(I7>E7())*(Y26*M8), where E7 represents hire date.

 

[Michael M]

So, did you resolve the problem ??

 

[mermar]

No, it does not seem to work either.

 

[mermar]

No, it did not work either.

 

[Saagar]

Keeping it simple, try:
=IF(I7>TODAY,Y26*M$8,0)

Function will return zero if the condition is false.

 

[jmthompson]

Yes the =IF would be easier. However I did find that my error lies with the fact the I7 will never be greater then today, since I7 represents the employees 90 days waiting period. So I tried, =IF(I7>E7())*(Y26*M8), where E7 represents hire date.

It would seem to me that if I7 = the date 90 days from the hire date and E7 is the hire date, the result of any If would always be true.

If you don't want to start accruing vacation until the date in I7, shouldn't the formula be

=IF(I7<=TODAY,Y26*M$8,0)

 

[mermar]

Nope, that gives me #name? error.