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

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,"")

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Ian" wrote:

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

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.

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

Have a nice time


Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com




--
Chris Bode