Convert Weight Ranges to Microliter Volumes in Excel
Question details
Return a microliter volume automatically based on a weight range in Excel.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet contains weights in grams that must be matched to predefined volume values.
- Observed behavior
- Each weight should return the volume assigned to its range, such as 19–20.99, 21–22.99, or 23–24.99 grams.
Confirm the approved weight ranges and their corresponding volumes before entering the formula. Enter weights as numbers in grams, without typing the unit in the cell.
Use IFS to match each weight range in Excel
Use this formula when your Excel version supports IFS and you want to return a predefined volume for each range.
The example assigns 100, 110, and 120 microliters to the three ranges. Replace these values with those from your approved schedule. This is a range lookup, not a physical conversion from mass to volume.
In your Excel worksheet, enter a numeric weight in grams in cell D1.
Select an output cell, such as E1, and enter =IFS(AND(D1>=19,D1<=20.99),100,AND(D1>=21,D1<=22.99),110,AND(D1>=23,D1<=24.99),120,TRUE,"Out of range").
Press Enter, then drag the fill handle from E1 down to apply the formula to additional weights in column D.

Use nested IF formulas in older Excel versions
Use nested IF and AND if IFS is unavailable in your version of Excel.
Match Weight Ranges to Volumes in WPS Spreadsheet
Use a nested IF formula in WPS Spreadsheet to return a preset microliter volume for each weight range, then fill it down for the rest of your data.
- 1. Open your worksheet: Open WPS Spreadsheet and create a workbook or open an Excel file containing your weights.
- 2. Enter a weight: Type a numeric weight in grams in cell D1.
- 3. Add the range formula: Select E1 and enter =IF(AND(D1>=19,D1<=20.99),100,IF(AND(D1>=21,D1<=22.99),110,IF(AND(D1>=23,D1<=24.99),120,"Out of range"))).
- 4. Fill and verify: Press Enter and drag the fill handle down column E. Check the results against your approved ranges and volumes.

Frequently Asked Questions
Is this formula a direct conversion from grams to microliters?
No. It returns a preset volume for each weight range. A physical mass-to-volume conversion requires the substance's density and appropriate units.
What happens if a weight falls between the listed ranges?
The formulas return “Out of range.” For example, 20.995 is greater than 20.99 but less than 21. Confirm how such values should be handled before changing the boundaries or rounding.
How do I add another weight range?
In the IFS formula, insert another AND condition and its volume before TRUE,"Out of range". Use the limits and volume specified in your approved schedule.
Why does Excel not recognize IFS?
Your Excel version may not support IFS. Use the nested IF formula instead, or open the workbook in a version of Excel that supports IFS.




