I need cell formula help
 

IN "AA6" I NEED A FORMULA

IF AA7 IS BETWEEN -.03 AND .04
TRUE SUM(O6:S6)+SUM(U6:Y6)
FALSE DO NOTHING

I need cell formula help
 

Try this...

=IF(AND(AA7=-0.03,AA7<=0.04),SUM(O6:S6)+SUM(U6:Y6),"")

--
Rick (MVP - Excel)


"j5b9721" wrote in message
...
IN "AA6" I NEED A FORMULA

IF AA7 IS BETWEEN -.03 AND .04
TRUE SUM(O6:S6)+SUM(U6:Y6)
FALSE DO NOTHING

I need cell formula help
 

Hi Rick, it works good so far! Thank you!!!!

But now I find that I need to add more to this too,
=IF(AND(AA59=-0.03,AA59<=0.04,Z59=-3%,Z59<=3%),SUM(O58:S58)+SUM(U58:Y58),"")
with the Z59 section.

I need to add to the formula "Z58" & "Z59" to be within a 10% range (5%up &
-5%down) of each other.
But I need "Z59=-3%,Z59<=3%" part to work also. Do you have an idea how to
do this???

Thanks for your time!!!!
Joe


"j5b9721" wrote:

IN "AA6" I NEED A FORMULA

IF AA7 IS BETWEEN -.03 AND .04
TRUE SUM(O6:S6)+SUM(U6:Y6)
FALSE DO NOTHING

I need cell formula help
 

Hi Rick, it works good so far! Thank you!!!!

But now I find that I need to add more to this too,
=IF(AND(AA59=-0.03,AA59<=0.04,Z59=-3%,Z59<=3%),SUM(O58:S58)+SUM(U58:Y58),"")
with the Z59 section.

I need to add to the formula "Z58" & "Z59" to be within a 10% range (5%up &
-5%down) of each other.
But I need "Z59=-3%,Z59<=3%" part to work also. Do you have an idea how to
do this???

Thanks for your time!!!!
Joe


"j5b9721" wrote:

IN "AA6" I NEED A FORMULA

IF AA7 IS BETWEEN -.03 AND .04
TRUE SUM(O6:S6)+SUM(U6:Y6)
FALSE DO NOTHING