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