Forum Discussion

Copper Contributor

Apr 03, 2019

Solved

Need help using a "FIND" with a "If"

I am trying to create a simple way of showing availability for a form. The codes represent times and dates before and after the event. For example: "-4d" = 4 Days before the event available durin...

Formulas and Functions

Macros and VBA

Muncie
Apr 03, 2019
I figured it out, so I thought I would share in case anyone else is looking for this:

=IF(ISNUMBER(FIND("-6d",AJ3)),"Yes","No")

That fixed the problem and did what I needed.
Muncie

Muncie

Copper Contributor

Apr 03, 2019

I figured it out, so I thought I would share in case anyone else is looking for this:

=IF(ISNUMBER(FIND("-6d",AJ3)),"Yes","No")

That fixed the problem and did what I needed.

Muncie