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
- Is this income indian or foreign income?
- REGARDING GST ON COMMERICIAL PROPERTY
- 15ca /15cb whose income tax login? remitter or nri seller's login?
- Regarding Documentation & Compliances for Opening of Unit of Pvt Ltd.
- TDS U/S. 194NF
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- ITC temporary reversal and reclaim
- GST on export of services and Input Credit
- Applicable TDS rate for sale of property in Nov 2024
- Donation Receipt u/s 80G
- Quiery in relation to GST liability in case of an advocate who has obtained GST registration.
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
- Query for dubts
- Regarding einvoice taken on nil rated sales
Trending Online Classes
CAclubindia
