I am trying to create a formula whereby -
if cell D3 is equal to 1, then cell H3 is equal to cell H2 plus 1 BUT if cell D3 is blank or a number greater than 6 is entered, then cell H3 remains blank.
I am using Excel 2007 and am not very experienced with its' formulas yet.
Anybody help please?
Ian
Bookmarks