TheVALUE functionis used to make Excel treat time value at each threshold as a number instead of next.
Note: you could alsouse VLOOKUP to replace nested IFsif you like.
More than one condition can be tested by nesting IF functions.
a number, date, or time format) into a numeric value.
Normally, the VALUE function is not needed in Excel, because Excel automatically converts text to numeric values.
