IF Farmula in Excel
This query is : Resolved
18 October 2010
HOW CAN I GIVE ONE FORMULA OF THIS
IF(A1=B1,C1,D1) OR IF(A2=B2,C2,D2) OR IF(A3=B3,C3,D3)............
IF(A1=B1,C1,D1) OR IF(A2=B2,C2,D2) OR IF(A3=B3,C3,D3)............
19 October 2010
your question is not clear. please ask in foum section and attached your file for example. so expert can solved your problems.
19 October 2010
https://www.caclubindia.com/forum/total-formulas-in-excel--105971.asp
Please see this forum post. You will find useful files containing all excel formulas.
Please see this forum post. You will find useful files containing all excel formulas.
19 October 2010
Data Taken in Excel is as follows >
A1 1(D8) A2 2(F8)
B1 5(D9) B2 1(F9)
C1 2(D10) C2 2(F10)
D1 3(D11) D2 3(F11)
Formula Used
IF(OR(D8=D9,D8=D10,D8=D11),D8,IF(OR(F8=F9,F8=F10,F8=F11),F8,0))
Check if it works for you.
Regards
A1 1(D8) A2 2(F8)
B1 5(D9) B2 1(F9)
C1 2(D10) C2 2(F10)
D1 3(D11) D2 3(F11)
Formula Used
IF(OR(D8=D9,D8=D10,D8=D11),D8,IF(OR(F8=F9,F8=F10,F8=F11),F8,0))
Check if it works for you.
Regards
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
- TDS 194-T applicability
- Fixe term employment
- Is any professional CA is here please reply
- GST ITC REVERSE
- TDS on TRUST
- Putting a heading on received mail
- Regarding Applicability of Tax Audit u/s 44AB
- Consolidated financials
- RCM ISSUE ON RENT AND TRANSPORTATION CHARGES
- TDS on Complimentary "Desi Ghee and Gold Coin" Provided to KBC Contestants
- Withdrawal in cash from partners capital account by partner
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- STATUTORY AUDIT OF A SMALL PRIVATE COMPANY INCORPORATED ON 28.03.2025
- 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
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
