hi
for your first formula...
=if(C130, something/2,"")
for your second...
need more info. you can key on a date for example if cell A1 had a date of
12/31/07 in it then....
=if(day(A1)30, DoMath,DoOtherMath)

You really need to profide more info when posting here. otherwise you get
the above.

post back with more info if you need to.

Regards
FSt1


"Scooterrabbit" wrote:

I am trying to set up a formula to calculate:

If cell C13 is greater than zero - divide by 2, if C13 is 0 - then leave
blank.

Also, I am trying to get it calculate the averages of cells but in instance
of 5th Sunday - need it to divide by 5 instead 4

Thanks