Microsoft excel
This query is : Resolved
Querist : Anonymous
Querist :
Anonymous
(Querist)
03 July 2012
Greetings of the day to all experts!!!
In excel if we want to find the difference in two numeric value we simply put formula =cell"A1"-cell"B1"
But if there are two alpha numeric values then how can we find the difference with the help of formula...
ex: in cell A1 = Sunil99
in cell B1 = Suneel99
In excel if we want to find the difference in two numeric value we simply put formula =cell"A1"-cell"B1"
But if there are two alpha numeric values then how can we find the difference with the help of formula...
ex: in cell A1 = Sunil99
in cell B1 = Suneel99
03 July 2012
For what purpose do you want to find the difference between two alphanumeric values?
If you want to find whether the two values are equal or not, use A1 = B1.
It will display 'True' or 'False'.
If you want to find whether the two values are equal or not, use A1 = B1.
It will display 'True' or 'False'.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
- Resigning a auditor from the company for misconduct
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
- LLP audit under companies act
- Experienced CA recommendation from Kolkata for FNO return filing
- Interest Reporting in Form 168
- Sales of goods of amount Rs77 lakhs to a party
- Tax Demand of ₹4,650 for AY 2026-27
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
