function and formula required

  • Thread starter Thread starter Ann Hardy
  • Start date Start date
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
 
Hi

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