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
- Price inclusive or exclusive of GST while made entry in P& L Account
- Tds on commission charges
- Applicability of GST on Salary Reimbursement Component
- TDS on Complimentary "Desi Ghee and Gold Coin" Provided to KBC Contestants
- Dep. as per companies act
- Minimum tax payable to file Updated return
- Renovation exp. in flat by family member
- Change Of Karta In Case of Death
- New GST registration for new place of business.
- FAST-DS Scheme - Foreign Assets
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Starting trading business
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
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
Quick Links
09 September 2026
Semi Qualified CA / CA Inter - 2 Groups Cleared
Getmyca Consultant Pvt Ltd
New Delhi
CA Inter
View Details
ARTICLESHIP
15 September 2026
Freelance Taxation Content Writer Intern
Interactive Media Pvt Ltd.
New Delhi
CA Inter
View Details
ARTICLESHIP
07 September 2026
Article/ Paid Assistant
Murali and Sumeet Chartered Accountant
Bengaluru
CA Foundation
View Details
CCI
Pro
CAclubindia
