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
- INTEREST APPLICABLE ON ITC REVERSAL PORTION
- Capital gain from sale of house property
- Current Account Opening for Sole Proprietorship with Udyam Certificate - Zero Turnover
- TDS on Purchase of Immovable Property by NRI from NRI
- Value of property in capital gain
- When TDS on GST applied
- Before GSTAT- APL-02 Vs APL-04
- Annual return in Gst
- Copyright software
- Transporter Declaration form
- Opting our of sec 44AD
- GST Treatment of Insurance Commission for Existing GST Holder
- Cash gift by grand mother to her grand daughter
- Tax amount diff in Gstr1 and 3B in tax compare reports
- Tds on GST in connection with sale to public company
- Restoration of certificate of practice
- Regarding change in correspondence address in SSP portal
- No Compliences after incorporation
- USEFUL LIFE OF USED/SECOND HAND COMMERCIAL VEHICLES
- Claiming TDS deducted by builder on Hardship compensation and Corpus
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
