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

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

 

[Don Guillett]

Put what?

 

[xlm]

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

 

[Niek Otten]

In Sheet1, A10:

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

In Sheet1, A11:

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

 

[Julie]

Put the value of C30 into the appropriate cell.

Sorry

 

[Pete_UK]

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

 

[Sheeloo]

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,"")

 

[xlm]

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

 

[Shane Devenshire]

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,"")

 

[Julie]

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