how do i place a date as an 'or' logical in a formula?

[ucastores]

=IF(OR(SEPT!J46<0,I16>0),SUM(E25:E33)/9,"")
i am trying to place a date after the i16>0 but i don't know how. i want
the date so that all 3 items have to be true for the sum to be used. The
date has to be after Sept 30 of the current year.
i am using office 2002, excel

 

[Bob I]

If ALL items must be TRUE then you must use "AND" not "OR"
thusly

=IF(AND(SEPT!J46<0,I16>0,Today()>9/30/2004),SUM(E25:E33)/9,"")

 

[ucastores]

how do i write sept!j46 to be equal to or greater than 0? it turns out if it
is Zero or a positive number and the date is after the end of sept i need to
average it like i have done. Can you help me?

 

[ucastores]

Excuse the last post, i found out how to do it.

If ALL items must be TRUE then you must use "AND" not "OR"
thusly

=IF(AND(SEPT!J46<0,I16>0,Today()>9/30/2004),SUM(E25:E33)/9,"")

 

[ucastores]

This formula is not working for me. i tried it with novJ46 and
today(),11/30/2004 and i am still getting the sum and division when it should
be giving me a blank. i think.
i am not setting this formula up correctly and i don't know what i am doing
wrong.
i need to add the november cases done (even if the total is 0) to the
running total for the year and divide it by the number of the month it is in,
in this case 11. i am trying to get a running monthly average. BUT if that
month hasn't yet been reached yet i want that cell to be blank. can you help
me?

 

[Bob I]

Try walking before you run.

Put each of the three parts of the "AND" section in a seperate cell and
see what they evaluate to. If ANY one of the three parts evaluates to
False ( a zero) then the "" will be the result. If you get each of the
working right then the IF statment will work.

 

[ucastores]

here's what i did and the results i got, =if(nov!j46>=0,sum(e25:e33),"") --
results were #value. i expected that as the cell in question has a 0 in it.
The default number in that cell is 0 and sometimes if no cases are done it
becomes the total for the month. =if(today()>11/30/2004,sum(e25:e33),"")
returned the sum, which i did not expect. i dropped the I16 cell as i think
it's not needed.
Am i putting the date in correctly? Do i need to format the cell in some
fashion to accept the date? I have it formatted as an accounting cell with
one decimal place.

I may need to only check for the date and if it is after the month in
question then i need the sum, otherwise i need the cell blank.

 

[ucastores]

Ok, next installment: I've learned how to formula audit and the way the date
is entered is giving me a false figure. it keeps wanting to divide
(11/30/2004), so now i know why i am getting the sum, but not how to input
the date so that it will give a the sequential number microsoft uses for
calculations. any suggestions, comments, insights?
i really appreciate the help you've given so far, it is helping me think in
this vein.

 

[ucastores]

Ok, this i think is the last installment, lol. To put a date in so that it
recognizes it as a date and puts in the sequential number microsoft needs it
has to be put in as datevalue("11/30/2004").
Thanks for your help.

 

[Bob I]

Looks like you have gotten it sorted. Good job!

Ok, this i think is the last installment, lol. To put a date in so that it
recognizes it as a date and puts in the sequential number microsoft needs it
has to be put in as datevalue("11/30/2004").
Thanks for your help.

: