Hello guys,
I have been trying to work on excel and I've figured out some stuff lately but I am stuck at something for which I am posting here.
Here's a screenshot of the result I want to
\1
I want 70 & 50 from Column 1 to subtract from 50 & 40 from Column 2 and the result should be shown in the next column i.e Addition. How can I achieve this result can anybody please guide me in this ?
Thanks in advance,
Sabhay Tandon
Try this:
=LEFT(A2,2)-LEFT(B2,2) &","& RIGHT(A2,2)-RIGHT(B2,2)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thank you so muchWorks like a charm.
If possible can you pls tell me what does 2 denote in the below function.
=LEFT(A2,2)-LEFT(B2,2) &","& RIGHT(A2,2)-RIGHT(B2,2)
Last edited by Sabhay92; 12-17-2013 at 10:31 AM.
From the help of excel (F1)
Syntax:
LEFT(text,num_chars)
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks