Dear all Excel Experts,
I have used this function and obtained the derived result. However, when I try to calculate the total of this particular column, the result is showing as 0. How can I get the correct total? I have attached the Excel file. Request your assistance in resolving 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
Acknowledge(0)
Amend(0)
2I have used this function and obtained the derived result. However, when I try to calculate the total of this particular column, the result is showing as 0. How can I get the correct total? I have attached the Excel file. Request your assistance in resolving 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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From Saudi Arabia, Riyadh
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Nizamabad
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Excel Functions Dictionary.xls