Dear all Excel Experts
I have used this function, i have got derieved result, When i want to total of this particular colomn result is showing 0. How do get the total. I have attached the excel file. Requet to solve this issue.
Srinivas Vayuveguala
Hyderabad
099512321510
=IF(E9>=15000,"200",IF(E9>=10000,"150",IF(E9>=8000 ,"100",IF(E9>=5000,"60",IF(E9>=3000,"30",IF(E9> =0, "0"))))))
From India, Hyderabad
2I have used this function, i have got derieved result, When i want to total of this particular colomn result is showing 0. How do get the total. I have attached the excel file. Requet to solve this issue.
Srinivas Vayuveguala
Hyderabad
099512321510
=IF(E9>=15000,"200",IF(E9>=10000,"150",IF(E9>=8000 ,"100",IF(E9>=5000,"60",IF(E9>=3000,"30",IF(E9> =0, "0"))))))
From India, Hyderabad
Hi Srini, Try to use SUMProduct Function — =SUMPRODUCT((J8:J13=J8:J13)*J8:J13) By the way I have attached your file after summarize. Regards, Rashid
From Saudi Arabia, Riyadh
From Saudi Arabia, Riyadh
Hello Srini, It’s simple just remove the " " quotes in the formula which u have given in true value. Eg: if(e9>15000,200,e9>10000,150........) It works...
From India, Nizamabad
From India, Nizamabad
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Excel function dictionary.xls