How to get the positive value only from different excel sheets

[cursor_type]

How can I get the positive value only. For example Sheet 1 has a positive number (e.g. 2) and Sheet 2 has a negative number (e.g. -5) then I would like the positive number (2) to be in my Sheet 3.

 

[Colo]

Let's say, assuming the target range is A1 cell for each sheet.
The formula in A1 Sheet3 would be like this.

=IF(Sheet1!A1>Sheet2!A1,Sheet1!A1,Sheet2!A1)

Is one number always positive and one number always negative?
If not, I believe that there are some patterns as follows.

Pattern1:Sheet 1 has a positive number and Sheet 2 has a negative number.
The positive number to be in Sheet 3.

Pattern2:Sheet 1 has a positive number and Sheet 2 has a positive number.
Which positive number should be placed in Sheet 3?

Pattern3:Sheet 1 has a negative number and Sheet 2 has a negative number.
No number to be placed in Sheet 3. (Correct?)

 

[cursor_type]

Let's say, assuming the target range is A1 cell for each sheet.
The formula in A1 Sheet3 would be like this.

=IF(Sheet1!A1>Sheet2!A1,Sheet1!A1,Sheet2!A1)

Is one number always positive and one number always negative?
If not, I believe that there are some patterns as follows.

Pattern1:Sheet 1 has a positive number and Sheet 2 has a negative number.
The positive number to be in Sheet 3.

Pattern2:Sheet 1 has a positive number and Sheet 2 has a positive number.
Which positive number should be placed in Sheet 3?

Pattern3:Sheet 1 has a negative number and Sheet 2 has a negative number.
No number to be placed in Sheet 3. (Correct?)

Pattern 1: Yes. And also the other way around. If Sheet 1 has a negative number and Sheet 2 has a positive. The positive number to be in Sheet 3. Is that possible?

Pattern 2: If both sheet has positive number I want the sum of both positive number.

Pattern 3: Correct.

 

[Colo]

If there are multiple conditions, it is easier to create a formula for each condition and combine them at the end. (In the following sample, the negative case includes 0 .)
Once you are familiar with Excel, try to come up with short, efficient formulas.

=IF(AND(Sheet1!A1<=0,Sheet2!A1<=0),"",IF(AND(Sheet1!A1>0,Sheet2!A1>0),SUM(Sheet1!A1,Sheet2!A1),IF(Sheet1!A1>Sheet2!A1,Sheet1!A1,Sheet2!A1)))

Book2
	A	B	C	D
1	1
2
3	Patterns		Formula	Results
4	Patern#1	Sheet 1 has a positive number and Sheet 2 has a negative number. And also the other way around.	1	The positive number
5	Patern#2	Sheet 1 has a positive number and Sheet 2 has a positive number.	FALSE	Sum
6	Patern#3	Sheet 1 has a negative number and Sheet 2 has a negative number.	FALSE	Empty
Sheet3

Cell Formulas
Range	Formula
A1	A1	=IF(AND(Sheet1!A1<=0,Sheet2!A1<=0),"",IF(AND(Sheet1!A1>0,Sheet2!A1>0),SUM(Sheet1!A1,Sheet2!A1),IF(Sheet1!A1>Sheet2!A1,Sheet1!A1,Sheet2!A1)))
C4	C4	=IF(Sheet1!A1>Sheet2!A1,Sheet1!A1,Sheet2!A1)
C5	C5	=IF(AND(Sheet1!A1>0,Sheet2!A1>0),SUM(Sheet1!A1,Sheet2!A1))
C6	C6	=IF(AND(Sheet1!A1<=0,Sheet2!A1<=0),"")

 

[cursor_type]

If there are multiple conditions, it is easier to create a formula for each condition and combine them at the end. (In the following sample, the negative case includes 0 .)
Once you are familiar with Excel, try to come up with short, efficient formulas.

=IF(AND(Sheet1!A1<=0,Sheet2!A1<=0),"",IF(AND(Sheet1!A1>0,Sheet2!A1>0),SUM(Sheet1!A1,Sheet2!A1),IF(Sheet1!A1>Sheet2!A1,Sheet1!A1,Sheet2!A1)))

Book2
	A	B	C	D
1	1
2
3	Patterns		Formula	Results
4	Patern#1	Sheet 1 has a positive number and Sheet 2 has a negative number. And also the other way around.	1	The positive number
5	Patern#2	Sheet 1 has a positive number and Sheet 2 has a positive number.	FALSE	Sum
6	Patern#3	Sheet 1 has a negative number and Sheet 2 has a negative number.	FALSE	Empty
Sheet3

Cell Formulas
Range	Formula
A1	A1	=IF(AND(Sheet1!A1<=0,Sheet2!A1<=0),"",IF(AND(Sheet1!A1>0,Sheet2!A1>0),SUM(Sheet1!A1,Sheet2!A1),IF(Sheet1!A1>Sheet2!A1,Sheet1!A1,Sheet2!A1)))
C4	C4	=IF(Sheet1!A1>Sheet2!A1,Sheet1!A1,Sheet2!A1)
C5	C5	=IF(AND(Sheet1!A1>0,Sheet2!A1>0),SUM(Sheet1!A1,Sheet2!A1))
C6	C6	=IF(AND(Sheet1!A1<=0,Sheet2!A1<=0),"")

It works! Thank you so much!

 

[bebo021999]

In sheet3!A1:

=IF(MEDIAN(Sheet1!A1,Sheet2!A1,0)=0,MAX(Sheet1!A1,Sheet2!A1),Sheet1!A1+Sheet2!A1)

 

[cursor_type]

In sheet3!A1:

=IF(MEDIAN(Sheet1!A1,Sheet2!A1,0)=0,MAX(Sheet1!A1,Sheet2!A1),Sheet1!A1+Sheet2!A1)

Thank you. This helps too.