COMPOSITE FUNCTION: DGET/ ERRORTYPE

Hello, 

How do I join these two formuals to fit in one cell? (i23)

 

=DGET(A3:I17,”Total”,D21:D22)

 

=IF(ERROR.TYPE(I24)=6,CHOOSE(ERROR.TYPE(I24)=6,”Enter correct T/number in D22″),CHOOSE(ERROR.TYPE(I24)=3,”NO RECORDS FOUND”))

 

 

 

By: Danny

Leave a Reply

Your email address will not be published. Required fields are marked *