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

how to use isnumber with this formula..
 

Possibly:

=if(isnumber(E6),Formula,"")

--
Regards,
Tom Ogilvy


"adi" wrote:

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

how to use isnumber with this formula..
 

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

how to use isnumber with this formula..
 

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

how to use isnumber with this formula..
 

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