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

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

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

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

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

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


"Julie" wrote:

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

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

In Sheet1, A10:

=IF(Sheet2!C300,1,"")

In Sheet1, A11:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

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

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

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

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 -

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

I think what Julie needs is this
In Sheet1, A10:

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

In Sheet1, A11:

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


"Niek Otten" wrote:

In Sheet1, A10:

=IF(Sheet2!C300,1,"")

In Sheet1, A11:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

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

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









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

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

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


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

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

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

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

"Shane Devenshire" wrote:

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


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

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