Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |