Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formula
Hello,
I would like to add cell a1 and b1 only if the totals of three other cells are within a specific parameter. For example; if my formula is is cell d1 and it is looking at m1 and the result of m1 are 0 - 5, or 35 - 45, or 75 to 85, then I would like for d1 then to add cell a1 and b1. If m1 has any other result I do not want d1 to take any action (remain 0). Thanks for the help Jim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formula
Something like this
=IF(M1="",0,IF(OR(AND(M1=0,M1<=5),AND(M1=35,M1<= 45),AND(M1=75,M1<=85)),SUM(A1:B1),0)) I added a condition checking if M1 is blank, then return zero or else it would add A1 and B1 for a blank as well -- Regards, Peo Sjoblom "Jim" wrote in message ... Hello, I would like to add cell a1 and b1 only if the totals of three other cells are within a specific parameter. For example; if my formula is is cell d1 and it is looking at m1 and the result of m1 are 0 - 5, or 35 - 45, or 75 to 85, then I would like for d1 then to add cell a1 and b1. If m1 has any other result I do not want d1 to take any action (remain 0). Thanks for the help Jim |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formula
=IF(OR(AND(M1=0,M1<=5),AND(M1=35,M1<=45),AND(M1 =75,M1<=85)),A1+B1,0)
-- David Biddulph "Jim" wrote in message ... Hello, I would like to add cell a1 and b1 only if the totals of three other cells are within a specific parameter. For example; if my formula is is cell d1 and it is looking at m1 and the result of m1 are 0 - 5, or 35 - 45, or 75 to 85, then I would like for d1 then to add cell a1 and b1. If m1 has any other result I do not want d1 to take any action (remain 0). Thanks for the help Jim |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formula
Peo,
Thanks for the response. If I were to use this formula in more than one ajacent cells; for example in d1, d2, d3, etc. How do I get the d2 to not show the result if d1 has? I would like to avoid two consecutive cells from returning data. "Peo Sjoblom" wrote: Something like this =IF(M1="",0,IF(OR(AND(M1=0,M1<=5),AND(M1=35,M1<= 45),AND(M1=75,M1<=85)),SUM(A1:B1),0)) I added a condition checking if M1 is blank, then return zero or else it would add A1 and B1 for a blank as well -- Regards, Peo Sjoblom "Jim" wrote in message ... Hello, I would like to add cell a1 and b1 only if the totals of three other cells are within a specific parameter. For example; if my formula is is cell d1 and it is looking at m1 and the result of m1 are 0 - 5, or 35 - 45, or 75 to 85, then I would like for d1 then to add cell a1 and b1. If m1 has any other result I do not want d1 to take any action (remain 0). Thanks for the help Jim |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formula
Try this is D2 (and copy downwards)?
=IF(D1<0,IF(M2="",0,IF(OR(AND(M2=0,M2<=5),AND(M2 =35,M2<=45),AND(M2=75,M2<=85)),SUM(A2:B2),0)), 0)--David Biddulph"Jim" wrote in ... Peo, Thanks for the response. If I were to use this formula in more than one ajacent cells; for example in d1, d2, d3, etc. How do I get the d2 to not show the result if d1 has? I would like to avoid two consecutive cells from returning data. "Peo Sjoblom" wrote: Something like this=IF(M1="",0,IF(OR(AND(M1=0,M1<=5),AND(M1 =35,M1<=45),AND(M1=75,M1<=85)),SUM(A1:B1),0)) I added a condition checking if M1 is blank, then return zero or else it would add A1 and B1 for a blank as well "Jim" wrote in message ... Hello, I would like to add cell a1 and b1 only if the totals of three othercells are within a specific parameter. For example; if my formula is is cell d1 and it is looking at m1 andthe result of m1 are 0 - 5, or 35 - 45, or 75 to 85, then I would like ford1 then to add cell a1 and b1. If m1 has any other result I do not wantd1 to take any action (remain 0). Thanks for the help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formula | Excel Discussion (Misc queries) | |||
conditional formula | Excel Worksheet Functions | |||
Conditional Formula help | Excel Discussion (Misc queries) | |||
Conditional Formula to indicate Formula in cell | New Users to Excel | |||
conditional formula | Excel Discussion (Misc queries) |