ABS Function | Learn Advanced Excel Online Function 01 | YVamshi

 ABS Function | Learn Excel Online Function 01

Hello, in this blog we are going to learn Advanced Level of Excel Chapter 01. You can ask me queries in any of the languages (English / Hindi / Telugu)

Let's get into the topic.

Function Name: ABS function

Category: Math and trigonometry

Type and description: Returns the absolute value of a number

It means, if your output is in negative values, this function will convert all those negative values to positive values. For example, if your value is -45 then by using this function, you can convert -45 to 45.

Remember that, this function can convert only numerical values. If your cell contains any other characters, then this function returns an error. Here I am giving you the sample data with the best examples.

Sample Data to Practice:

Product Name	Buy Price	Sell Price	P&L Amount	All values in Positive
Demo Product 01	93	554	461
Demo Product 02	345	721	376
Demo Product 03	359	1607	1248
Demo Product 04	929	1405	476
Demo Product 05	113	1303	1190
Demo Product 06	654	1388	734
Demo Product 07	116	670	554
Demo Product 08	229	911	682
Demo Product 09	118	1573	1455
Demo Product 10	209	324	115
Demo Product 11	427	374	-53
Demo Product 12	994	1746	752
Demo Product 13	278	742	464
Demo Product 14	133	379	246
Demo Product 15	420	584	164
Demo Product 16	408	1907	1499
Demo Product 17	678	744	66
Demo Product 18	177	20	-157
Demo Product 19	291	577	286
Demo Product 20	907	503	-404
Demo Product 21	125	1036	911
Demo Product 22	78	1101	1023
Demo Product 23	946	585	-361
Demo Product 24	176	1624	1448
Demo Product 25	50	1408	1358
Demo Product 26	228	1102	874
Demo Product 27	44	641	597
Demo Product 28	125	644	519
Demo Product 29	398	516	118
Demo Product 30	961	793	-168
Demo Product 31	581	1520	939
Demo Product 32	948	1208	260
Demo Product 33	539	1023	484
Demo Product 34	232	809	577
Demo Product 35	550	1954	1404
Demo Product 36	141	1760	1619
Demo Product 37	462	1733	1271
Demo Product 38	330	678	348
Demo Product 39	349	503	154
Demo Product 40	588	141	-447
Demo Product 41	239	1234	995
Demo Product 42	93	1956	1863
Demo Product 43	972	693	-279
Demo Product 44	211	264	53
Demo Product 45	719	218	-501
Demo Product 46	679	1041	362
Demo Product 47	187	1833	1646
Demo Product 48	674	1210	536
Demo Product 49	853	652	-201
Demo Product 50	422	483	61
Demo Product 51	220	1098	878
Demo Product 52	666	986	320
Demo Product 53	288	1002	714
Demo Product 54	567	1739	1172
Demo Product 55	777	798	21
Demo Product 56	147	417	270
Demo Product 57	697	1345	648
Demo Product 58	784	1341	557
Demo Product 59	927	211	-716
Demo Product 60	835	1665	830
Demo Product 61	282	1152	870
Demo Product 62	900	1730	830
Demo Product 63	161	1207	1046
Demo Product 64	994	927	-67
Demo Product 65	17	589	572
Demo Product 66	427	1345	918
Demo Product 67	389	1726	1337
Demo Product 68	981	392	-589
Demo Product 69	262	164	-98
Demo Product 70	7	342	335
Demo Product 71	729	1075	346
Demo Product 72	759	3	-756
Demo Product 73	385	2	-383
Demo Product 74	980	1961	981
Demo Product 75	711	1285	574
Demo Product 76	512	165	-347
Demo Product 77	677	1998	1321
Demo Product 78	443	217	-226
Demo Product 79	899	704	-195
Demo Product 80	119	1817	1698
Demo Product 81	161	1559	1398
Demo Product 82	641	572	-69
Demo Product 83	465	842	377
Demo Product 84	260	61	-199
Demo Product 85	786	1741	955
Demo Product 86	653	534	-119
Demo Product 87	430	600	170
Demo Product 88	915	783	-132
Demo Product 89	149	206	57
Demo Product 90	754	1384	630
Demo Product 91	502	1165	663
Demo Product 92	742	1778	1036
Demo Product 93	118	891	773
Demo Product 94	732	1765	1033
Demo Product 95	193	1493	1300
Demo Product 96	78	24	-54
Demo Product 97	26	1920	1894
Demo Product 98	658	535	-123
Demo Product 99	828	1520	692
Demo Product 100	754	1384	630

 

The output of the above data without errors:

Product Name	Buy Price	Sell Price	P&L Amount	All values in Positive
Demo Product 01	93	554	461	461
Demo Product 02	345	721	376	376
Demo Product 03	359	1607	1248	1248
Demo Product 04	929	1405	476	476
Demo Product 05	113	1303	1190	1190
Demo Product 06	654	1388	734	734
Demo Product 07	116	670	554	554
Demo Product 08	229	911	682	682
Demo Product 09	118	1573	1455	1455
Demo Product 10	209	324	115	115
Demo Product 11	427	374	-53	53
Demo Product 12	994	1746	752	752
Demo Product 13	278	742	464	464
Demo Product 14	133	379	246	246
Demo Product 15	420	584	164	164
Demo Product 16	408	1907	1499	1499
Demo Product 17	678	744	66	66
Demo Product 18	177	20	-157	157
Demo Product 19	291	577	286	286
Demo Product 20	907	503	-404	404
Demo Product 21	125	1036	911	911
Demo Product 22	78	1101	1023	1023
Demo Product 23	946	585	-361	361
Demo Product 24	176	1624	1448	1448
Demo Product 25	50	1408	1358	1358
Demo Product 26	228	1102	874	874
Demo Product 27	44	641	597	597
Demo Product 28	125	644	519	519
Demo Product 29	398	516	118	118
Demo Product 30	961	793	-168	168
Demo Product 31	581	1520	939	939
Demo Product 32	948	1208	260	260
Demo Product 33	539	1023	484	484
Demo Product 34	232	809	577	577
Demo Product 35	550	1954	1404	1404
Demo Product 36	141	1760	1619	1619
Demo Product 37	462	1733	1271	1271
Demo Product 38	330	678	348	348
Demo Product 39	349	503	154	154
Demo Product 40	588	141	-447	447
Demo Product 41	239	1234	995	995
Demo Product 42	93	1956	1863	1863
Demo Product 43	972	693	-279	279
Demo Product 44	211	264	53	53
Demo Product 45	719	218	-501	501
Demo Product 46	679	1041	362	362
Demo Product 47	187	1833	1646	1646
Demo Product 48	674	1210	536	536
Demo Product 49	853	652	-201	201
Demo Product 50	422	483	61	61
Demo Product 51	220	1098	878	878
Demo Product 52	666	986	320	320
Demo Product 53	288	1002	714	714
Demo Product 54	567	1739	1172	1172
Demo Product 55	777	798	21	21
Demo Product 56	147	417	270	270
Demo Product 57	697	1345	648	648
Demo Product 58	784	1341	557	557
Demo Product 59	927	211	-716	716
Demo Product 60	835	1665	830	830
Demo Product 61	282	1152	870	870
Demo Product 62	900	1730	830	830
Demo Product 63	161	1207	1046	1046
Demo Product 64	994	927	-67	67
Demo Product 65	17	589	572	572
Demo Product 66	427	1345	918	918
Demo Product 67	389	1726	1337	1337
Demo Product 68	981	392	-589	589
Demo Product 69	262	164	-98	98
Demo Product 70	7	342	335	335
Demo Product 71	729	1075	346	346
Demo Product 72	759	3	-756	756
Demo Product 73	385	2	-383	383
Demo Product 74	980	1961	981	981
Demo Product 75	711	1285	574	574
Demo Product 76	512	165	-347	347
Demo Product 77	677	1998	1321	1321
Demo Product 78	443	217	-226	226
Demo Product 79	899	704	-195	195
Demo Product 80	119	1817	1698	1698
Demo Product 81	161	1559	1398	1398
Demo Product 82	641	572	-69	69
Demo Product 83	465	842	377	377
Demo Product 84	260	61	-199	199
Demo Product 85	786	1741	955	955
Demo Product 86	653	534	-119	119
Demo Product 87	430	600	170	170
Demo Product 88	915	783	-132	132
Demo Product 89	149	206	57	57
Demo Product 90	754	1384	630	630
Demo Product 91	502	1165	663	663
Demo Product 92	742	1778	1036	1036
Demo Product 93	118	891	773	773
Demo Product 94	732	1765	1033	1033
Demo Product 95	193	1493	1300	1300
Demo Product 96	78	24	-54	54
Demo Product 97	26	1920	1894	1894
Demo Product 98	658	535	-123	123
Demo Product 99	828	1520	692	692
Demo Product 100	754	1384	630	630

 

The output of above data with errors:

Product Name	Buy Price	Sell Price	P&L Amount	All values in Positive
Demo Product 01	93	554	Profit.461	#VALUE!
Demo Product 02	345	721	Profit.376	#VALUE!
Demo Product 03	359	1607	Profit.1248	#VALUE!
Demo Product 04	929	1405	Profit.476	#VALUE!
Demo Product 05	113	1303	Profit.1190	#VALUE!
Demo Product 06	654	1388	Profit.734	#VALUE!
Demo Product 07	116	670	Profit.554	#VALUE!
Demo Product 08	229	911	Profit.682	#VALUE!
Demo Product 09	118	1573	Profit.1455	#VALUE!
Demo Product 10	209	324	115	115
Demo Product 11	427	374	-53	53
Demo Product 12	994	1746	752	752
Demo Product 13	278	742	464	464
Demo Product 14	133	379	246	246
Demo Product 15	420	584	164	164
Demo Product 16	408	1907	1499	1499
Demo Product 17	678	744	66	66
Demo Product 18	177	20	-157	157
Demo Product 19	291	577	286	286
Demo Product 20	907	503	-404	404
Demo Product 21	125	1036	911	911
Demo Product 22	78	1101	1023	1023
Demo Product 23	946	585	-361	361
Demo Product 24	176	1624	1448	1448
Demo Product 25	50	1408	1358	1358
Demo Product 26	228	1102	874	874
Demo Product 27	44	641	Profit.597	#VALUE!
Demo Product 28	125	644	Profit.519	#VALUE!
Demo Product 29	398	516	Profit.118	#VALUE!
Demo Product 30	961	793	Loss.-168	#VALUE!
Demo Product 31	581	1520	Profit.939	#VALUE!
Demo Product 32	948	1208	260	260
Demo Product 33	539	1023	484	484
Demo Product 34	232	809	577	577
Demo Product 35	550	1954	1404	1404
Demo Product 36	141	1760	1619	1619
Demo Product 37	462	1733	1271	1271
Demo Product 38	330	678	348	348
Demo Product 39	349	503	154	154
Demo Product 40	588	141	-447	447
Demo Product 41	239	1234	995	995
Demo Product 42	93	1956	1863	1863
Demo Product 43	972	693	-279	279
Demo Product 44	211	264	53	53
Demo Product 45	719	218	Loss.-501	#VALUE!
Demo Product 46	679	1041	Profit.362	#VALUE!
Demo Product 47	187	1833	Profit.1646	#VALUE!
Demo Product 48	674	1210	Profit.536	#VALUE!
Demo Product 49	853	652	Loss.-201	#VALUE!
Demo Product 50	422	483	Profit.61	#VALUE!
Demo Product 51	220	1098	Profit.878	#VALUE!
Demo Product 52	666	986	Profit.320	#VALUE!
Demo Product 53	288	1002	Profit.714	#VALUE!
Demo Product 54	567	1739	1172	1172
Demo Product 55	777	798	21	21
Demo Product 56	147	417	270	270
Demo Product 57	697	1345	648	648
Demo Product 58	784	1341	557	557
Demo Product 59	927	211	-716	716
Demo Product 60	835	1665	830	830
Demo Product 61	282	1152	870	870
Demo Product 62	900	1730	830	830
Demo Product 63	161	1207	1046	1046
Demo Product 64	994	927	-67	67
Demo Product 65	17	589	572	572
Demo Product 66	427	1345	918	918
Demo Product 67	389	1726	1337	1337
Demo Product 68	981	392	-589	589
Demo Product 69	262	164	-98	98
Demo Product 70	7	342	335	335
Demo Product 71	729	1075	346	346
Demo Product 72	759	3	-756	756
Demo Product 73	385	2	-383	383
Demo Product 74	980	1961	981	981
Demo Product 75	711	1285	574	574
Demo Product 76	512	165	-347	347
Demo Product 77	677	1998	1321	1321
Demo Product 78	443	217	-226	226
Demo Product 79	899	704	-195	195
Demo Product 80	119	1817	Profit.1698	#VALUE!
Demo Product 81	161	1559	Profit.1398	#VALUE!
Demo Product 82	641	572	Loss.-69	#VALUE!
Demo Product 83	465	842	Profit.377	#VALUE!
Demo Product 84	260	61	Loss.-199	#VALUE!
Demo Product 85	786	1741	Profit.955	#VALUE!
Demo Product 86	653	534	Loss.-119	#VALUE!
Demo Product 87	430	600	Profit.170	#VALUE!
Demo Product 88	915	783	-132	132
Demo Product 89	149	206	57	57
Demo Product 90	754	1384	630	630
Demo Product 91	502	1165	663	663
Demo Product 92	742	1778	1036	1036
Demo Product 93	118	891	773	773
Demo Product 94	732	1765	1033	1033
Demo Product 95	193	1493	1300	1300
Demo Product 96	78	24	-54	54
Demo Product 97	26	1920	1894	1894
Demo Product 98	658	535	-123	123
Demo Product 99	828	1520	692	692
Demo Product 100	754	1384	630	630

 

Complete Formula view:

Product Name	Buy Price	Sell Price	P&L Amount	All values in Positive
Demo Product 01	93	554	Profit.461	=ABS(D2)
Demo Product 02	345	721	Profit.376	=ABS(D3)
Demo Product 03	359	1607	Profit.1248	=ABS(D4)
Demo Product 04	929	1405	Profit.476	=ABS(D5)
Demo Product 05	113	1303	Profit.1190	=ABS(D6)
Demo Product 06	654	1388	Profit.734	=ABS(D7)
Demo Product 07	116	670	Profit.554	=ABS(D8)
Demo Product 08	229	911	Profit.682	=ABS(D9)
Demo Product 09	118	1573	Profit.1455	=ABS(D10)
Demo Product 10	209	324	=C11-B11	=ABS(D11)
Demo Product 11	427	374	=C12-B12	=ABS(D12)
Demo Product 12	994	1746	=C13-B13	=ABS(D13)
Demo Product 13	278	742	=C14-B14	=ABS(D14)
Demo Product 14	133	379	=C15-B15	=ABS(D15)
Demo Product 15	420	584	=C16-B16	=ABS(D16)
Demo Product 16	408	1907	=C17-B17	=ABS(D17)
Demo Product 17	678	744	=C18-B18	=ABS(D18)
Demo Product 18	177	20	=C19-B19	=ABS(D19)
Demo Product 19	291	577	=C20-B20	=ABS(D20)
Demo Product 20	907	503	=C21-B21	=ABS(D21)
Demo Product 21	125	1036	=C22-B22	=ABS(D22)
Demo Product 22	78	1101	=C23-B23	=ABS(D23)
Demo Product 23	946	585	=C24-B24	=ABS(D24)
Demo Product 24	176	1624	=C25-B25	=ABS(D25)
Demo Product 25	50	1408	=C26-B26	=ABS(D26)
Demo Product 26	228	1102	=C27-B27	=ABS(D27)
Demo Product 27	44	641	Profit.597	=ABS(D28)
Demo Product 28	125	644	Profit.519	=ABS(D29)
Demo Product 29	398	516	Profit.118	=ABS(D30)
Demo Product 30	961	793	Loss.-168	=ABS(D31)
Demo Product 31	581	1520	Profit.939	=ABS(D32)
Demo Product 32	948	1208	=C33-B33	=ABS(D33)
Demo Product 33	539	1023	=C34-B34	=ABS(D34)
Demo Product 34	232	809	=C35-B35	=ABS(D35)
Demo Product 35	550	1954	=C36-B36	=ABS(D36)
Demo Product 36	141	1760	=C37-B37	=ABS(D37)
Demo Product 37	462	1733	=C38-B38	=ABS(D38)
Demo Product 38	330	678	=C39-B39	=ABS(D39)
Demo Product 39	349	503	=C40-B40	=ABS(D40)
Demo Product 40	588	141	=C41-B41	=ABS(D41)
Demo Product 41	239	1234	=C42-B42	=ABS(D42)
Demo Product 42	93	1956	=C43-B43	=ABS(D43)
Demo Product 43	972	693	=C44-B44	=ABS(D44)
Demo Product 44	211	264	=C45-B45	=ABS(D45)
Demo Product 45	719	218	Loss.-501	=ABS(D46)
Demo Product 46	679	1041	Profit.362	=ABS(D47)
Demo Product 47	187	1833	Profit.1646	=ABS(D48)
Demo Product 48	674	1210	Profit.536	=ABS(D49)
Demo Product 49	853	652	Loss.-201	=ABS(D50)
Demo Product 50	422	483	Profit.61	=ABS(D51)
Demo Product 51	220	1098	Profit.878	=ABS(D52)
Demo Product 52	666	986	Profit.320	=ABS(D53)
Demo Product 53	288	1002	Profit.714	=ABS(D54)
Demo Product 54	567	1739	=C55-B55	=ABS(D55)
Demo Product 55	777	798	=C56-B56	=ABS(D56)
Demo Product 56	147	417	=C57-B57	=ABS(D57)
Demo Product 57	697	1345	=C58-B58	=ABS(D58)
Demo Product 58	784	1341	=C59-B59	=ABS(D59)
Demo Product 59	927	211	=C60-B60	=ABS(D60)
Demo Product 60	835	1665	=C61-B61	=ABS(D61)
Demo Product 61	282	1152	=C62-B62	=ABS(D62)
Demo Product 62	900	1730	=C63-B63	=ABS(D63)
Demo Product 63	161	1207	=C64-B64	=ABS(D64)
Demo Product 64	994	927	=C65-B65	=ABS(D65)
Demo Product 65	17	589	=C66-B66	=ABS(D66)
Demo Product 66	427	1345	=C67-B67	=ABS(D67)
Demo Product 67	389	1726	=C68-B68	=ABS(D68)
Demo Product 68	981	392	=C69-B69	=ABS(D69)
Demo Product 69	262	164	=C70-B70	=ABS(D70)
Demo Product 70	7	342	=C71-B71	=ABS(D71)
Demo Product 71	729	1075	=C72-B72	=ABS(D72)
Demo Product 72	759	3	=C73-B73	=ABS(D73)
Demo Product 73	385	2	=C74-B74	=ABS(D74)
Demo Product 74	980	1961	=C75-B75	=ABS(D75)
Demo Product 75	711	1285	=C76-B76	=ABS(D76)
Demo Product 76	512	165	=C77-B77	=ABS(D77)
Demo Product 77	677	1998	=C78-B78	=ABS(D78)
Demo Product 78	443	217	=C79-B79	=ABS(D79)
Demo Product 79	899	704	=C80-B80	=ABS(D80)
Demo Product 80	119	1817	Profit.1698	=ABS(D81)
Demo Product 81	161	1559	Profit.1398	=ABS(D82)
Demo Product 82	641	572	Loss.-69	=ABS(D83)
Demo Product 83	465	842	Profit.377	=ABS(D84)
Demo Product 84	260	61	Loss.-199	=ABS(D85)
Demo Product 85	786	1741	Profit.955	=ABS(D86)
Demo Product 86	653	534	Loss.-119	=ABS(D87)
Demo Product 87	430	600	Profit.170	=ABS(D88)
Demo Product 88	915	783	=C89-B89	=ABS(D89)
Demo Product 89	149	206	=C90-B90	=ABS(D90)
Demo Product 90	754	1384	=C91-B91	=ABS(D91)
Demo Product 91	502	1165	=C92-B92	=ABS(D92)
Demo Product 92	742	1778	=C93-B93	=ABS(D93)
Demo Product 93	118	891	=C94-B94	=ABS(D94)
Demo Product 94	732	1765	=C95-B95	=ABS(D95)
Demo Product 95	193	1493	=C96-B96	=ABS(D96)
Demo Product 96	78	24	=C97-B97	=ABS(D97)
Demo Product 97	26	1920	=C98-B98	=ABS(D98)
Demo Product 98	658	535	=C99-B99	=ABS(D99)
Demo Product 99	828	1520	=C100-B100	=ABS(D100)
Demo Product 100	754	1384	=C101-B101	=ABS(D101)