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
|