function and formula required

A

Ann Hardy

I am trying to get the result from one worksheet on to another by askin
if 3 arguments which refer to data on sheet 1 are true then give me th
result in the tri-angulated cell in this cell on sheet
 
A

Andy B

Hi

You need something like:
=IF(AND(Sheet2!A2=10,Sheet2!B2=20,Sheet2!C2=30),"True","False")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top