If function

[Sarah7828]

Hi

I am trying to create an if function in column w

I have come up with two separate functions need then combined in Cell W5


Formula 1 for “money out”


=If ( ISNUMBER(SEARCH(“Money Out”,Q5)>0,
-T5,””)

Formula 2 for “money in”

If(isnumber(search (“Money In”, R5)>0,U5,””)

Can you let me know how to combine the formulas

 

[Peter_SSs]

With your sample data every row has "Money Out" in col Q and "Money In" in col R. So which one takes precedence?
What are your expected results in col W for that sample data, & why?
The best way to give sample data (& expected results) is with XL2BB
(If you have trouble with XL2BB, review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.)

 

[Peter_SSs]

Is it just this you are after?

25 02 20.xlsm
	T	U	V	W
5		6		6
6				0
7		1000		1000
8		18000		18000
9		4000		4000
10	100			-100
11	500			-500
12	6			-6
13	3			-3
Sheet5

Cell Formulas
Range	Formula
W5:W13	W5	=U5-T5

 

[StephenCrump]

Duplicate: Can I use sumif and if function together

But is this what you mean:

	Q	R	S	T	U	V	W
5	Money Out	Money In		0.00	202,470.97		202,470.97
6	Money Out	Money In		0.00			0.00
7	Money Out	Money In		0.00	1,010.10		1,010.10
8	Money Out	Money In		0.00	13,832.20		13,832.20
9	Money Out	Money In		0.00	1,406.77		1,406.77
10	Money Out	Money In		103,683.96			-103,683.96
11	Money Out	Money In		50,593.74			-50,593.74
Sheet1

Cell Formulas
Range	Formula
W5:W11	W5	=(R5="Money In")*U5-(Q5="Money Out")*T5

 

[Peter_SSs]

Duplicate to: Can I use sumif and if function together

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.