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
- Itr 1 processing
- Off Market debit and credit transaction
- Showing Gift from relative in ITR for this year
- ITR 2 Short Term gain & Long term gain
- Share accounting-->fifo - capital gain - period as per fifo?
- ITR selection for salaries and capital gain less than L
- Short Term Capital gain on shares bought and sold after 2018 onwards
- ITR returnFY25-26
- Form 10E u/s 89(1). Need clarification because experts opinions differ !!!!
- INCOME TAX ON REDEVELOPEMENT OF FLAT
- Reporting Income under Section 44ADA
- ITR 1: Details for showing Exempt Income
- Gst invoice numbering and delivery challan numbering
- Sales amount in Gstr1
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
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
