I need cell formula help

[j5b9721]

IN "AA6" I NEED A FORMULA

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

 

[Rick Rothstein]

Try this...

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

 

[j5b9721]

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]

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