THANK YOU EVERYONE FOR YOUR HELP. IT WORKED :-) I so appreciate it!

"Shane Devenshire" wrote:

Hi,

In A11 on sheet1

=IF(Sheet2!C30<0,Sheet2!C30,"")

in A10 of sheet1

=IF(A11="",Sheet2!C30,"")

If you range name C30 to T then you can avoid the sheet references and your
formulas become:
=IF(T<0,T,"")
and
=IF(A11="",T,"")


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Julie" wrote in message
...
I am currently working in a spreadsheet with two tabs. On the first tab I
want to have a formula that essentially says "If cell C30 on tab 2 is
negative" put in Cell A10 on tab 1 but "If cell C30 on tab 2 is positive"
put
in Cell A11 tab 1. I am not sure how to write the formula but I know
there
has to be a way! Can anyone help me? I would so appreciate the help.

Thank you!!