Check Moisture Content
As a Concrete Mixer, I need to quickly check if the 'Moisture %' of the aggregates is between 3% and 5% (inclusive). If it falls within this optimal range, I want the status to display 'Optimal'. Otherwise, it should indicate 'Adjust Needed' so I know to modify the water-cement ratio.
=IF(AND(B2>=3, B2<=5), "Optimal", "Adjust Needed") How it works: This formula uses the IF function combined with the AND function. The AND function checks two conditions simultaneously: if the moisture percentage in cell B2 is greater than or equal to 3, AND if it is less than or equal to 5. If both conditions are TRUE, the AND function returns TRUE, and the IF function then outputs 'Optimal'. If either condition is FALSE (meaning the moisture is outside the 3-5% range), the AND function returns FALSE, and the IF function outputs 'Adjust Needed'. This provides an immediate status check for each batch of aggregates.
Data Setup
| Batch ID | Moisture % |
|---|---|
| Batch 101 | 4.2 |
| Batch 102 | 2.8 |
| Batch 103 | 5.0 |
| Batch 104 | 5.5 |
| Batch 105 | 3.0 |
| Batch 106 | 1.9 |
Step-by-Step Guide
Open your Excel sheet containing the aggregate moisture data.
Identify the column where 'Moisture %' is recorded (e.g., Column B).
Click on the first empty cell where you want the status to appear (e.g., C2, if B2 contains the first moisture value).
Type the formula: `=IF(AND(B2>=3, B2<=5), "Optimal", "Adjust Needed")`
Press Enter. The cell will now display 'Optimal' or 'Adjust Needed' based on the moisture percentage in B2.
Drag the fill handle (the small square at the bottom-right of cell C2) down to apply the formula to the rest of your data.