Function Problems

Convert Weight Ranges to Microliter Volumes in Excel

Natalie TaylorNatalie Taylor Nov 18, 2026 868 views

Question details

Return a microliter volume automatically based on a weight range in Excel.

Convert Weight Ranges to Microliter Volumes 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.
Before you start

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.

Solution 1Recommended

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.

1
Enter the weight

In your Excel worksheet, enter a numeric weight in grams in cell D1.

2
Enter the formula

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").

3
Check and fill down

Press Enter, then drag the fill handle from E1 down to apply the formula to additional weights in column D.

Use IFS to match each weight range in Excel
Check range boundaries: Values outside the listed intervals, including 20.995 and weights of 25 grams or more, return “Out of range.” Add conditions only when the correct ranges and volumes are known.
WPS Spreadsheet

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. 1. Open your worksheet: Open WPS Spreadsheet and create a workbook or open an Excel file containing your weights.
  2. 2. Enter a weight: Type a numeric weight in grams in cell D1.
  3. 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. 4. Fill and verify: Press Enter and drag the fill handle down column E. Check the results against your approved ranges and volumes.
Match gram ranges to predefined microliter valuesOpen and edit Microsoft Excel XLSX filesUse familiar spreadsheet formulas and fill controlsWork with a free, easy-to-use office suite
microsoft office alternative - wps office

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.