how to create a condition in excel.
This query is : Resolved
ramanpreet kaur bhatia
(Querist)
08 June 2009
How to create a condition in excel so that information has to be neccessarily be filled in a cell to proceed further?
10 June 2009
You can use if function andif function orif function etc., you can also download the business functions software for the same.
11 June 2009
Further reply : from T. S. Sivarama Krisnan
How to create a condition in excel so that information has to be neccessarily be filled in a cell to proceed further?
Your desired task can be achieved in Excel by using IF function command
What Does It Do?
This function tests a condition.
If the condition is met it is considered to be TRUE.
If the condition is not met it is considered as FALSE.
Depending upon the result, one of two actions will be carried out.
Syntax
=IF(Condition,ActionIfTrue,ActionIfFalse)
The Condition is usually a test of two cells, such as A1=A2.
The ActionIfTrue and ActionIfFalse can be numbers, text or calculations.
Formatting
No special formatting is required.
Example
The marks obtained by Mr. A in three levels of excel proficiency tests are given below with differential pass standards
If the Marks obtained are greater than or equal to the Standard of pass, he is declared as “Pass”. Else, his result will be declared as “Fail”
Exam Level Marks obtained Standard of Pass Result
Basic 75 40 Pass =IF(C43>=D43,”Pass”,”Fail”)
Advanced 60 60 Pass =IF(C44>=D44,”Pass”,”Fail”)
Expertise 65 75 Fail =IF(C45>=D45,”Pass”,”Fail”)
Further reply : from T. S. Sivarama Krisnan
How to create a condition in excel so that information has to be neccessarily be filled in a cell to proceed further?
Your desired task can be achieved in Excel by using IF function command
What Does It Do?
This function tests a condition.
If the condition is met it is considered to be TRUE.
If the condition is not met it is considered as FALSE.
Depending upon the result, one of two actions will be carried out.
Syntax
=IF(Condition,ActionIfTrue,ActionIfFalse)
The Condition is usually a test of two cells, such as A1=A2.
The ActionIfTrue and ActionIfFalse can be numbers, text or calculations.
Formatting
No special formatting is required.
Example
The marks obtained by Mr. A in three levels of excel proficiency tests are given below with differential pass standards
If the Marks obtained are greater than or equal to the Standard of pass, he is declared as “Pass”. Else, his result will be declared as “Fail”
Exam Level Marks obtained Standard of Pass Result
Basic 75 40 Pass =IF(C43>=D43,”Pass”,”Fail”)
Advanced 60 60 Pass =IF(C44>=D44,”Pass”,”Fail”)
Expertise 65 75 Fail =IF(C45>=D45,”Pass”,”Fail”)
02 September 2009
Suppose you want to force user to enter some data in A1, then A2, A3 and so on. You don't want the user to skip entering data in any cell in Coloumn A. Then use this formula. Select the entire coloumn, Go to data validation. choose custom, uncheck ignore blank, and use the following formula,
=COUNTIF($A$1:$A1,"")=0
Use any desired error message.
Now enter any data in A1. skip A2 and try entering the data in A3, or skip A1 and start entering directly in A2. It won't allow.
Hope this helps.
=COUNTIF($A$1:$A1,"")=0
Use any desired error message.
Now enter any data in A1. skip A2 and try entering the data in A3, or skip A1 and start entering directly in A2. It won't allow.
Hope this helps.
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
- Gst credit note by supplier
- Movement of goods by packers and movers - type of sale - Reg.
- GST on reimbursement of expenses
- Due date for filing return for the partner in partnership subjected to Tax Audit
- Missed uploading GST Invoice
- Query on effect of registration of property
- Gratuity paid to legal heir above 20 lakh is taxable or not
- Wrong CMPo8 file
- Equity Share Sale and Purchase
- Goodwill transfer of deceased father’s firm – ICAI applying a 27.04.2026 cut-off to the 3 year limit
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- "Please ensure that the Total of the Deductions u/s 54F match the same in Table D in Sch CG"
- Need to correct "Whether it is last installment " response in Form 26 QB
- " Income from House Property " in joint names of co-owners
- REGARDING TDS RETURN OF FORM 27Q
- Notice under e-Verification Scheme
- GST demand notice for ITC reversal against exempted supply.
- RCM ON SECURITY CHARGES FROM INDIVIDUALS
- How to get money back from delisted company
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
