Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISNUMBER | Excel Discussion (Misc queries) | |||
ISNUMBER | Excel Worksheet Functions | |||
ISNUMBER | Excel Worksheet Functions | |||
ISNUMBER | Excel Worksheet Functions | |||
ISNUMBER | Excel Programming |