How to calculate PERCENTAGE in excel? | Percentage Formula #shorts #excel

preview_player
Показать описание
Learn how to calculate PERCENTAGE in excel? | Percentage Formula #shorts #excel


#exceltricks #tutorialspoint #youtubeshorts #excelshortcut #exceltips #exceltutorial #percentageformula
Рекомендации по теме
Комментарии
Автор

Lets do that a lot more accurate.
=C2/B2
Format it as percentage and it will say 90%
Use the percentage in another calculation and it works properly unlike how you did it. Also, try formatting your way as percentage. It will show 9000%.

If you still want the outcome to look like the way you did it you just make it like
=C2/B2*100
There is no need for ( ), Not even in your formula.

MunchWillbeBlue
Автор

You can do it like this : mark obtained divided total mark thin change the data type to percentage

abofaresssss
Автор

Isn't that complicating? Coz if you just divide the total marks obtained by the number of subjects it will still be same ? Please correct me if I'm wrong

prnjl_grg
Автор

Which formula to get text name or area name should show by adding numbers / pincode /values in cells by given Raw data

mshttcretion