Hello,
I need help fixing a formula. I receive the #REF! error and the wrong answers at times and would like some help fixing it. I need to find the next greater value of a value selected. The values reside in column C and the values to choose between for the next greater value reside in columns D:G and the formula itself is in column H.
Example:
A1: Date
B2: Time
C2: 0.9833 - Find next greater value.
D2: 0.9831
E2: 0.9823
F2: 0.9873
G2: 0.9865
H2: #REF - #REF! Error
I2: .9865 (Is what the answer should be in H.)
I attached a spreadsheet that has other examples and the formula itself. Thanking you in advance for any and all help.
Bookmarks