how to use isnumber with this formula..
hi all..
can anyone tell me how i can use isnumber with this formula ..
=IF(WEEKDAY(E6,2)5," ",INT((DAY(E6)+WEEKDAY(E6-DAY(E6)+2)+3)/7)).. or
if anyone can suggest how i can get a blank cell instead of getting
#value ....
the same is true for this formula also
=IF(c2=1,b2,"") i am getting a #value error for this formula also .. if
anyone can help me out on this it will be great.. thanx in advance..
adi
|