Hello All,
I am trying to do an If/Then with a range and can't quite seem to figure it out.
Example:
If A2 = 1 through 6, value of cell A3 should be 7, if not value would be 0. I am using Excel 2010 and for some reason I was thinking I was able to do this in Excel 2007. Any assistance would be greatly appreciated.
I am trying to do an If/Then with a range and can't quite seem to figure it out.
Example:
If A2 = 1 through 6, value of cell A3 should be 7, if not value would be 0. I am using Excel 2010 and for some reason I was thinking I was able to do this in Excel 2007. Any assistance would be greatly appreciated.