formula question
 

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

formula question
 

=IF(Sheet1!A10,"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



"JaneSmith" wrote in message
...
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

formula question
 

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