Struggling with two formulas in one cell

[King Mustard]

Here is my example:

I have the following formulas:

D2 =SUM(B2:C2)
E2 =D2/A2
F2 =SUM(A2-D2)

I am hoping I can combine D2 and E2 by having D2 show this: "£100 (10%)"

Can anyone please help?

 

[Fluff]

If you combine the Formulae in D2 & E2 the result will be text & therefore the formula in F2 will fail.

 

[Sufiyan97]

Do you want something like:

Book6
	A	B	C	D	E	F	G	H
1
2				€ 100.00	10%	"£100 (10%)"
3
4
5
Sheet1

Cell Formulas
Range	Formula
F2	F2	=CONCATENATE("""","£",D2," (",TEXT(E2,"0%"),")","""")

 

[Joe4]

Also note that the SUM function in this formula is not necessary:

=SUM(A2-D2)

The SUM formula is used to add up the values in a multi-cell range (like your formula in cell D2).
There is no need to use it in F2, just use:

=A2-D2

 

[King Mustard]

Do you want something like:

Book6
	A	B	C	D	E	F	G	H
1
2				€ 100.00	10%	"£100 (10%)"
3
4
5
Sheet1

Cell Formulas
Range	Formula
F2	F2	=CONCATENATE("""","£",D2," (",TEXT(E2,"0%"),")","""")

Hi @Sufiyan97,

eb_1232947-1.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1	2022-23
2																Total pay before deductions	Deductions							Final money in	Tax code
3	Period	Period ending	Pay date	Salary	Hours worked	Payslip hours	Rate	Base pay	Basic pay arrears	Mileage	Expenses	Non Consol Pay NP	Overtime	Tax (PAYE)	Adv. NR		Tax (PAYE)	Tax (NI)	Student loan	Employee pension	Pension arrears	Recov. Adv. NR	Total deduc.
4	1	30/04/22	27/04/22	£21,777	162.95	162.95	£11.14	£1,815			£15					£1,830	£127	£131	£11	£129			£399	£1,431	1257L
2017-2023

Cell Formulas
Range	Formula
P4	P4	=H4+I4+K4+L4+M4
W4	W4	=SUM(Q4:V4)
X4	X4	=P4-W4

That is the exact data I have.

I need W4 to show, for example: £399 (10%)

 

[kevin9999]

Do you mean like this:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
2																Total pay before deductions	Deductions							Final money in	Tax code
3	Period	Period ending	Pay date	Salary	Hours worked	Payslip hours	Rate	Base pay	Basic pay arrears	Mileage	Expenses	Non Consol Pay NP	Overtime	Tax (PAYE)	Adv. NR		Tax (PAYE)	Tax (NI)	Student loan	Employee pension	Pension arrears	Recov. Adv. NR	Total deduc.
4	1	30/04/2022	27/04/2022	£21,777	162.95	162.95	£11.14	£1,815			£15					£1,830	£127	£131	£11	£129			£398 (22%)	£1,432	1257L
Sheet1

Cell Formulas
Range	Formula
P4	P4	=SUM(H4:I4,K4:M4)
W4	W4	=CONCATENATE("£",SUM(Q4:V4)," (",TEXT(SUM(Q4:V4)/P4,"0%"),")")
X4	X4	=P4-SUM(Q4:V4)

 

[King Mustard]

Do you mean like this:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
2																Total pay before deductions	Deductions							Final money in	Tax code
3	Period	Period ending	Pay date	Salary	Hours worked	Payslip hours	Rate	Base pay	Basic pay arrears	Mileage	Expenses	Non Consol Pay NP	Overtime	Tax (PAYE)	Adv. NR		Tax (PAYE)	Tax (NI)	Student loan	Employee pension	Pension arrears	Recov. Adv. NR	Total deduc.
4	1	30/04/2022	27/04/2022	£21,777	162.95	162.95	£11.14	£1,815			£15					£1,830	£127	£131	£11	£129			£398 (22%)	£1,432	1257L
Sheet1

Cell Formulas
Range	Formula
P4	P4	=SUM(H4:I4,K4:M4)
W4	W4	=CONCATENATE("£",SUM(Q4:V4)," (",TEXT(SUM(Q4:V4)/P4,"0%"),")")
X4	X4	=P4-SUM(Q4:V4)

Perfect, thank you so much!

 

[kevin9999]

Perfect, thank you so much!

Glad we could help, and thanks for the feedback