if 200 and <300 formula
Or even
=A1*(A1200)*(A1<300)
Yeah, I was going to post that with an explanation that understanding this
construction will be helpful in making use of such functions as SUMPRODUCT
later on; but I had to take care of something and couldn't get back to my
computer until just now.
Rick
|