Percentage Calculator
Percentage is evaluated from Percentage, Base Number and Part / Result. The calculation reports X% of Y, Part is what% of Base and Original Before Percent.
Results
About the Percentage Calculator
The calculator uses a multi formula configuration. Each reported value is read as a direct evaluation of the stored rules with the declared field formats and units.
Formula basis:
Type 1 - X% of Y:
Result = Y x X / 100
Type 2 - Part is what% of Base:
Percentage = (Part / Base) x 100
Type 3 - Find Original (Base) when Part and% are known:
Base = Part / (Percentage / 100)
Interpret the outputs in the order shown by the result fields. Optional inputs affect only the outputs that depend on those variables.
Formula & How It Works
The calculation applies the following relations exactly as recorded in the metadata: Type 1 - X% of Y: Result = Y x X / 100 Type 2 - Part is what% of Base: Percentage = (Part / Base) x 100 Type 3 - Find Original (Base) when Part and% are known: Base = Part / (Percentage / 100) Each output field is produced by substituting the supplied inputs into the relevant relation and then applying the declared rounding or text format.
Worked Examples
Example 1: Shop Discount Calculation
Inputs
With Percentage = 25 and Base Number = 3,200 as the stated inputs, the result is X% of Y = 800, Part is what% of Base = 0% and Original Before Percent = 0. Each value corresponds to the declared output fields.
Example 2: Test Score Percentage
Inputs
With Base Number = 75 and Part / Result = 63 as the stated inputs, the result is X% of Y = 0, Part is what% of Base = 84% and Original Before Percent = inf. Each value corresponds to the declared output fields.
Example 3: Reverse GST Calculation
Inputs
With Percentage = 18 and Part / Result = 2,360 as the stated inputs, the result is X% of Y = 0, Part is what% of Base = inf% and Original Before Percent = 13,111.1111. Each value corresponds to the declared output fields.
Example 4: Commission on Sales
Inputs
With Percentage = 7.5 and Base Number = 850,000 as the stated inputs, the result is X% of Y = 63,750, Part is what% of Base = 0% and Original Before Percent = 0. Each value corresponds to the declared output fields.
Common Use Cases
- Calculate a discount on a purchase price
- Find what percentage a score represents
- Determine the original price before a sale