Just a slight amendment to Niek's suggestion, then:

In Sheet1, A10:

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

In Sheet1, A11:

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

Hope this helps.

Pete


On Jan 7, 5:04*pm, Julie wrote:
Put the value of C30 into the appropriate cell.

Sorry



"Don Guillett" wrote:
Put what?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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!!- Hide quoted text -

- Show quoted text -