correction-should be IF with na not vlookup
Yes
Works fine.
Thanks
Sverre
"Ron Coderre" skrev:
Try this:
=IF(ISNA(F8);1;0)
or
=--ISNA(F8)
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"sverre" wrote:
Sorry, wrong of me....
Below does not work when there is na. Can I correct it?
=IF(--F8="#N/A";1;0)
f8 is by the way a Vlookup that has catched a number.
sverre
br
sverre
|