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
[Login to view]
=IF(E9>=15000,"200",IF(E9>=10000,"150",IF(E9>=8000 ,"100",IF(E9>=5000,"60",IF(E9>=3000,"30",IF(E9> =0, "0"))))))
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
[Login to view]
=IF(E9>=15000,"200",IF(E9>=10000,"150",IF(E9>=8000 ,"100",IF(E9>=5000,"60",IF(E9>=3000,"30",IF(E9> =0, "0"))))))
1 Attachment(s) [Login To View]