Struggling with a Table from Class: Can Someone Explain How to Find the Answer?

Hi there,

I have this table from my teacher, but he didn't teach us how to get the answer (in red). Can someone please teach me how to do it? Is there any formula or method to follow? I have attached the file. Please help me... thank you.

Hi,

The information is incomplete. You can't make any calculations based on the data provided in the table alone. You need the basic data, such as the maximum and minimum salary in the sample survey.

To calculate the percentage in Excel, the formula is = value * percentage. For example, if Value = 2000 and Percentage = 10%, the process would be = A1 (Cell Name) or 2000 (Value) * 10%, resulting in an output of 200.

Hope this explanation works for you.

Regards,
Jayanta Brahma
HR
[Email Removed For Privacy Reasons]

Please help me figure out how to calculate the salary where basic, HRA, PF, ESI, and PTAX must be included.