Formula not working

[Ruenell]

I can't seem to get this to work
=IF(ISNUMBER(SEARCH("Rejected",A2)) =IF(isblank,"","Today"))

Any help would be appreciated.

Dorinda

 

[Fluff]

Could you please explain what you are trying to do?

 

[Ruenell]

I want it to look at the first column and if it contains Reject in it and the comments field is not blank I want to return todays date

 

[Fluff]

What column is the comments field in?

 

[Ruenell]

B2

 

[Ruenell]

I can get them to work seperately just cant get them to work togehter

=IF(ISNUMBER(SEARCH("Rejected",A2)),"ok","not") I added the OK not OK to make sure it was working I do not want it as part of the formula.
=IF(ISBLANK(B2),"",(TODAY()))

 

[Fluff]

How about
=IF(AND(ISNUMBER(SEARCH("Rejected",A2)),B2<>""),TODAY(),"")

 

[Ruenell]

YOU ROCK!!! THAT WORKED!!

Thank you so much!!

Dorinda

 

[Fluff]

You're welcome & thanks for the feedback