PDA

View Full Version : Formula help



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!

mdmackillop
06-06-2007, 09:43 AM
=IF(AND(LEN(B2)=1,B2=0),1,"")

Bob Phillips
06-06-2007, 09:56 AM
An alternative

=IF(AND(B2<>"",B2=0),1,"")