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
|