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!!