Thread
:
IF Question
View Single Post
#
3
Don Guillett
Posts: n/a
Have a look in HELP index for ISNA and the other IS functions.
--
Don Guillett
SalesAid Software
"carl" wrote in message
...
I have a lookup formula in col b that returns #N/A if it does not find the
lookup value. I would like to put a formula in col c that will only apply
if
the value in col b is not #N/A.
here's how my data looks and the formula in colb is if(a2<"open",D1,"")
State Symbol
closed ABC
open
Thank you in advance.
Reply With Quote