First one:

=IF(C130,C13/2,IF(C13=0,"","negative"))

You haven't said what to do if C13 is negative. If you want to treat
it the same as zero, or if it can never be negative, then you just
need:

=IF(C130,C13/2,"")

Second one:

I don't understand what you are asking for - perhaps if you can post
some more details of what you have and what you want to achieve?

Hope this helps.

Pete

On Nov 23, 10:32 pm, 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