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
- TDS related query on tds deducted and return filed but later on credit note issued
- Showing rebate on agricultural income in tax payable on total income
- TDS reverce related query
- GST Partners addition
- Non-disclosure of Foreign Shares & Dividend in Past ITRs – How to Rectify & Report Now?
- Complete TDS taxation rules for NRIs(Middle East) for Equity Mutual Funds
- EXEMPTION UNDER SECTION 54 FOR UNDER CONSTRUCTION FLAT
- ICWAI-Final best coaching center for online by English
- "Please ensure that the Total of the Deductions u/s 54F match the same in Table D in Sch CG"
- Refund_ Insufficient in credit ledger
Trending Online Classes
-
Input Tax Credit, GST refunds and Recovery of refunds- Roadblocks and way outs
CA Nipun Arora03 September 2025 -
GST LIVE Certification Course - 43rd Weekdays Batch(With Govt Certificate)
Industry Expert15 September 2025
CAclubindia
