Help on formula -

[Scooterrabbit]

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

 

[FSt1]

hi
for your first formula...
=if(C13>0, 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

 

[Pete_UK]

First one:

=IF(C13>0,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(C13>0,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