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 (" ") ?

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


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details