Excel formula
This query is : Resolved
24 June 2013
=if(cell id>0,G11+H11," ")
please let me know what is the function of the above apostrophees (" ") ?
please let me know what is the function of the above apostrophees (" ") ?
24 June 2013
please see formula for IF function
Ex:
=if( logical test,value if true,value if false)
it is u to define logical test and you can choose what value you want in case of true and what value you want in case of false
so in your case it says
if cell id > 0(if it is true) give value equal to G11+H11
if cell id >0(if it is false means less than 0) value will be blank(means no value will come a blank cell will remain if you apply this formuale
Thanks & regards
Ganesh babu k
Ex:
=if( logical test,value if true,value if false)
it is u to define logical test and you can choose what value you want in case of true and what value you want in case of false
so in your case it says
if cell id > 0(if it is true) give value equal to G11+H11
if cell id >0(if it is false means less than 0) value will be blank(means no value will come a blank cell will remain if you apply this formuale
Thanks & regards
Ganesh babu k
Message likes :
1 times
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
- Exiting partner in partnership firm in gst portal
- CLOSING STOCK QUERY
- Consequences of Non-Deduction of TDS under Income Tax???????????????
- IT returns for fresh job holders
- F&O reporting in ITR
- Difff in ais receipts and gst turnover
- ITR 44AD SECTION
- Technical Glitch in ITR-4 Online Form (AY 2026-27): Sec 44AE Partner Remuneration not mapping to E8
- Residential status of non resident
- NRI INSURANCE ADVISOR
- DUE DATE FOR ITR FILING
- Concept of Vendor and customner reconciliation
- Mistake in e-invoice identified after 24 hours
- EXPORT PAYMENT
- NRI ITR2 account in 2025-26.
- Query regarding reporting of exempt foreign remuneration in ITR (AY 2026-27)
- FEMA/RBI treatment — Amazon.ca arbitrage (US buy, Canada sell, goods never enter India)
- Goods return by customer
- INWARD REMITTANCE FOREIGN
- CPC and SAC
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
