Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help on formula -
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help on formula -
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help on formula -
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|