formula question

[JaneSmith]

I need help with three formulas. if anyone can help.

formula 1
Need a formula that says, if a cell in sheet1 has number greater than 0,
then put “Yes†in sheet2 otherwise null

formula 2
Need a formula that says if field is a, then put b, else carry data in a
column

Ei:
A B
C C
D D
A B

formula 3
Need a formula that says if cell = boat, then go to sheet2 and pull data.

thanks,
JaneS

 

[Peo Sjoblom]

=IF(Sheet1!A1>0,"Yes","")

=IF(A1="A","B",A1)

Don't know what you mean with the 3rd


replace A1 with the cell(s) in question


--


Regards,


Peo Sjoblom

 

[Spiky]

formula 3
Need a formula that says if cell = boat, then go to sheet2 and pull data.

thanks,
JaneS

I also don't know exactly what you mean, but I assume something like
this:
=IF(A1="boat",Sheet2!A1,"")