Jul 25 2019 06:17 AM
I need help please i have spreadsheet with input data and 2nd sheet that summarize the data
i want to use countif it is 5% lower than recommended but seem because of the formula it returns to 0
0.95 | 1.05 | Air Pressures found | |||
Recommended | Under-Inflated | over-inflated | Low Pressure | 0 | |
800 | 760 | 840 | Normal Pressure | 1 | |
650 | 617.5 | 682.5 | High Pressure | 0 | |
720 | 684 | 756 |
Jul 25 2019 06:43 AM
=COUNTIF('Air Pressure'!B7:C14;"<=J4") B7:c14 -data input sheet J4 =800*.95 =760 if that make sense