da_phat
05-22-2007, 03:14 AM
Hye there,
just would like to ask several questionr regarding if statement. How can i return a value of "blank" if the reference cell is "0" from the another workshhet. If the cell in the other worksheet contain value, it will return the values else will return "blank"The example are as follows
=if(sheet1!a1=0,"",=sheet1!a1)
many thanks
just would like to ask several questionr regarding if statement. How can i return a value of "blank" if the reference cell is "0" from the another workshhet. If the cell in the other worksheet contain value, it will return the values else will return "blank"The example are as follows
=if(sheet1!a1=0,"",=sheet1!a1)
many thanks