Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

how to calculate percentage with 2 decimal value and percentage sign?

when i Calculate percentage in libreoffice calc with 2 decimal point, it work properly. But when i want to add percentage % sign - Value will be changed, then show a wrong answer. My Operating System is ubuntu 12.04 LTS. LibreOffice Calc 3.5.7.2 my work details in Cell F2 Total Marks Obtained 460 Out of 700 then calculate percentage in cell G2 Place the cursor in cell G2, then type =(F2/700)*100 then press Enter. the percentahe is 65.71428571 then format cell in the percentage with 2 decimal point like 6571.53%. but its a wrong answer. Please help me to Calculate Percentage like 65.71%

how to calculate percentage with 2 decimal value and percentage sign?

when i Calculate percentage in libreoffice calc with 2 decimal point, it work properly. But when i want to add percentage % sign - Value will be changed, then show a wrong answer. My Operating System is ubuntu 12.04 LTS. LibreOffice Calc 3.5.7.2 my work details in Cell F2 Total Marks Obtained 460 Out of 700 then calculate percentage in cell G2 Place the cursor in cell G2, then type =(F2/700)*100 then press Enter. the percentahe is 65.71428571 then format cell in the percentage with 2 decimal point like 6571.53%. but its a wrong answer. Please help me to Calculate Percentage like 65.71%