Help on formula -

S

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
 
F

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
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top