Using If formula within two worksheets

I

Ian

Is there a way of using the IF formula to print what is in another cell on a
second worksheet if the answer is correct.
ie- in B3 asking if A3 is = 1, print out what is in B3 within worksheet #2

Thanks
 
S

Shane Devenshire

Hi,

Functions return calculated results to cells, they can not cause changes to
the GUI nor issue commands. The can hide or display the value in a cell or
range you intend to print. In B3 of Sheet1 you could enter the formula

=IF(A3=1,Sheet2!B3,"")
 
M

Matt

Do you want to print or just display the value? I agree with Shane, you
can't print, but you can make the sheet display the value and then print
later on.
 
C

Chris Bode

Well, you can use following formula to print the content of cell B3 i
sheet2 to any cell in sheet1
=IF(<condition>,Sheet2!B3,"")
if the specified condition in <condition> tags is met then the conten
of sheet2!B3 gets printed in the current cell in sheet1

Have a nice time


Chris
 
Top