guys that helped ... used IF(ISNUMBER())...it worked out and got the
results ... really appreciate it ... :) thanks a lot

adi
Tom Ogilvy wrote:
think he meant what I said:

=if(iserror(YourFunction),"",YourFunction)

or if you want blank for the function evaluating to an error and some other
response (but not the result of the function) if it doesn't.


=if(iserror(YourFunction),"",YourReturn)



--
Regards,
Tom Ogilvy



"Die_Another_Day" wrote:

You can also use the "iserror" function.
if(iserror(YourFunction,"",YourReturn))

HTH

Die_Another_Day
"adi" wrote in message
oups.com...
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