if functions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dlvv - 14 Jul 2006 17:22 GMT

I have the following formula in colmun Q
=IF(ISNA(Q12(T8,CPT!$B$64:$B$89,FALSE)),"",VLOOKUP(T8,CPT!$B$64:$D$89,3,FALSE))

I also want to add the condition that if in column I the age is less than 50
then return a value of blank.

Please help-

dlvv

Reply to this Message

Bob Phillips - 14 Jul 2006 17:43 GMT

=IF(OR(I8<50,ISNA(Q12(T8,CPT!$B$64:$B$89,FALSE))),"",VLOOKUP(T8,CPT!$B$64:$D
$89,3,FALSE))

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> I have the following formula in colmun Q

=IF(ISNA(Q12(T8,CPT!$B$64:$B$89,FALSE)),"",VLOOKUP(T8,CPT!$B$64:$D$89,3,FALS
E))

> I also want to add the condition that if in column I the age is less than 50
> then return a value of blank.
>
> Please help-
>
> dlvv

Reply to this Message