Not sure how to write a formula that I need! Please read!

  • Thread starter Thread starter Julie
  • Start date Start date
J

Julie

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!!
 
try this formula

=IF(Sheet2!C30<0,A10,A11)

this assume that your cell A10 and A11 are in Sheet1 and that there is
always a postitive or negative value in C30 of sheet2

HTH
--
If this posting was helpful, please click on the Yes button below

Thank You

cheers, francis
 
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
 
I think what Julie needs is this
In Sheet1, A10:

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

In Sheet1, A11:

=IF(Sheet2!C30>0,Sheet2!C30,"")
 
try this formula

In A10, place this
=IF(Sheet2!C3<=0,Sheet2!C3,"is postitive")

In A11, place this

=IF(Sheet2!C3>=0,Sheet2!C3,"is negative")

HTH

--
If this posting was helpful, please click on the Yes button below

Thank You

cheers, francis
 
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,"")
 
Back
Top