need to add + in diff. and

[sksanjeev786]

Hi Team,

Could you please let us know why I am getting data in decimals...
and also can we have a + symbol in a different scores.

FS_Taiwan.xlsx
	E		G	H	I	J	K	L	M	N	O	P
101	Tastes great		11	15					11	15	-4	11 (-4)
102	Is fun to drink		14	15					14	15	-1	14 (-0.999999999999998)
103	Is a refreshing beverage		16	15					16	15	1	16 (1)
104	Has the right amount of flavour		14	11					14	11	3	14 (3)
105	Is a brand I enjoy drinking		13	12					13	12	1	13 (1)
106	Is a brand I trust		11	12					11	12	-1	11 (-1)
107	Helps maintain a healthy lifestyle		16	15					16	15	1	16 (1)
108	Is a brand that is better for you		12	13					12	13	-1	12 (-1)
109	Is a brand I have as a treat		11	12					11	12	-1	11 (-1)
110	Is a drink to relax and unwind with		14	13					14	13	1	14 (1)
111	Is a brand I drink when socializing with friends and family		10	12					10	12	-2	10 (-2)
112	Has great tasting low or zero sugar options		13	13					13	13	0	13 (0)
113	Offers enhanced properties like antioxidants		14	12					14	12	2	14 (2)
114	Does not have an aftertaste		11	14					11	14	-3	11 (-3)
115	Is easily available		9	10					9	10	-1	9 (-1)
116	Is a brand that is environmentally conscious		15	14					15	14	1	15 (0.999999999999998)
117	Has recyclable packaging		20	17					20	17	3	20 (3)
118	Offers unique flavours compared to other drinks		13	13					13	13	0	13 (0)
FS

Cell Formulas
Range	Formula
G101:H118	G101	=INDEX(INDIRECT("'"&$A101&"'!A"&$C101&":IV"&$D101&""),MATCH($E101,INDIRECT("'"&$A101&"'!A"&$C101&":A"&$D101&""),0)+1,G$6)*100&" "&INDEX(INDIRECT("'"&$A101&"'!A"&$C101&":IV"&$D101&""),MATCH($E101,INDIRECT("'"&$A101&"'!A"&$C101&":A"&$D101&""),0)+2,G$6)
M101:N118	M101	=INDEX(INDIRECT("'"&$A101&"'!A"&$C101&":IV"&$D101&""),MATCH($E101,INDIRECT("'"&$A101&"'!A"&$C101&":A"&$D101&""),0)+1,M$6)*100
O101:O118	O101	=M101-N101
P101:P118	P101	=M101&" ("&O101&")"

 

[Peter_SSs]

Could you please let us know why I am getting data in decimals...

See here: Floating-point arithmetic may give inaccurate result in Excel - Office

Try this formula instead

=M101&" ("&IF(O101>0,"+","")&ROUND(O101,6)&")"

 

[sksanjeev786]

See here: Floating-point arithmetic may give inaccurate result in Excel - Office

Try this formula instead

=M101&" ("&IF(O101>0,"+","")&ROUND(O101,6)&")"

Thank you so much, Peter

it works very well and just wanted to check why we got data in decimal for a few cells.

Regards
Sanjeev

 

[Peter_SSs]

just wanted to check why we got data in decimal for a few cells.

Did you read the link that I supplied?

 

[sksanjeev786]

Did you read the link that I supplied?

Sorry Peter, I missed out the link you provided. sure I will go through the link and let you know if I have any further questions

Thank you again for your help on this

 

[Peter_SSs]

You're welcome.