No Tags Found!

srini_vs8562
2

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
Attached Files (Download Requires Membership)
File Type: xls excel if function.xls (16.5 KB, 6370 views)

Rashid Ahmed
78

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
Attached Files (Download Requires Membership)
File Type: xls excel if function.xls (28.5 KB, 1976 views)

mani.ragi
10

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
srini_vs8562
2

To : Dear Rashid & Dear Manikath, A Very good morning to you both. First let me thank you very much to you both, It worked out as you said. Thanks Srinivas
From India, Hyderabad
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.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.