Excel functions
This query is : Resolved
Querist : Anonymous
Querist :
Anonymous
(Querist)
16 October 2012
if(a4:ae4>9, then it has to minus 5 from the all the cells, where the cell has grater than 9.
pls help....thanks in advance
pls help....thanks in advance
16 October 2012
simple:
=if(a4>9,a4-5,a4)
copy and paste this formula in all the cells...
=if(a4>9,a4-5,a4)
copy and paste this formula in all the cells...
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
- Tax Audit Applicability – Newly Formed Partnership Firm with Profit Below 6%/8%
- TDS CREDIT MISMATCHING
- Buy back of shares u/s69
- Portuguese Civil Code IT Return
- Taxability of Partnership firm for FY 2025-26
- GST Rate for Catering Services
- IS AUDIT MANDATORY IF COMMISSION INCOME IS MORE THAN 50 LAKH
- TDS AND ITR ISSUE
- EMI ISSUE IN HOUSING LOAN OLD REGIME
- TODAY INCOME TAX SITE IS NOT WORKING ANY OFFICIAL EXTENSION
- 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
- Concept of Vendor and customner reconciliation
- Mistake in e-invoice identified after 24 hours
- EXPORT PAYMENT
- NRI ITR2 account in 2025-26.
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
