DarrylW
06-06-2007, 07:12 AM
Hi,
Hope someone can help me. As you can see in the attached row 2 has zeros entered into some of the cells but some are also left blank.
In the yellow highlighted area I want to put a formula which says if the above cell has a zero return a value of 1 but if the cell in row 2 is blank leave the below cell in the yellow area blank
Hope I'm making sense.
Thanks in advance for any help!
Hope someone can help me. As you can see in the attached row 2 has zeros entered into some of the cells but some are also left blank.
In the yellow highlighted area I want to put a formula which says if the above cell has a zero return a value of 1 but if the cell in row 2 is blank leave the below cell in the yellow area blank
Hope I'm making sense.
Thanks in advance for any help!