IFRA Formula Worksheet

Calculate each fragrance material’s finished-product percentage and flag blend-total, certificate, category, and entered-limit problems.

Worksheet version: 1.0 · Last reviewed: August 12, 2026 · Related guide: Open the guide

Privacy: Entries stay in this browser’s local storage and are not transmitted to Essence Authority. Do not enter medical information, payment-card data, passwords, or unnecessary personal information. Use Clear saved data to remove this worksheet’s local copy.

Instructions

Use one record for one defined product or event.
Enter exact IDs, versions, source locations, and dates instead of “current.”
Use neutral factual status words only.
Export or print the record if your organization requires a durable copy.

Stop triggers

Stop when a source is missing or conflicts, identity/classification is unclear, an incident occurred, or an authorized owner must decide. The worksheet records the gap; it does not resolve safety, legal, carrier, treatment, or pesticide questions.

Completed example

Material *	Supplier and lot *	Certificate version/date *	Category selected by user *	Percent of fragrance blend *	Total fragrance load (%) *	Material in finished product (%)	Entered certificate limit (%) *	Validation result
Citrus material	Supplier C / lot C26	Certificate dated 2026-04-30	User-selected candle category	20	6	1.2	1.0	Exceeds entered limit

Clean blank worksheet

Required fields are marked with an asterisk. Add as many records as needed, validate before export, and use the help text printed in every column.

No validation run yet.

Blend total: 0% — must equal 100%

Material *	Supplier and lot *	Certificate version/date *	Category selected by user *	Percent of fragrance blend *	Total fragrance load (%) *	Material in finished product (%)	Entered certificate limit (%) *	Validation result	Row controls
									Enable JavaScript to add editable rows, or print this blank row.