M
masterbaker
I am looking for a way to utilize the max or maxa functions that returns a
value depending on if it's less than a value. Assume:
B1 value is 8
A1:A5 values are:
2
4
6
9
15
I want a function that returns one of the values in A1:A5 that is the
largest number less than B1. This example would return the value 6. I
basically need a max function something like this:
Max(A1:A5)<B1 (Return the maximum number of A1:A5 that's less than B1)
This returns a false statement because the maximum number of A1:A5 is not
less than B1, but I want the value of 6 to be returned because it is the
largest number in the array that's less than B1. PLEASE HELP.
Thanks in advance for anything from anyone!
value depending on if it's less than a value. Assume:
B1 value is 8
A1:A5 values are:
2
4
6
9
15
I want a function that returns one of the values in A1:A5 that is the
largest number less than B1. This example would return the value 6. I
basically need a max function something like this:
Max(A1:A5)<B1 (Return the maximum number of A1:A5 that's less than B1)
This returns a false statement because the maximum number of A1:A5 is not
less than B1, but I want the value of 6 to be returned because it is the
largest number in the array that's less than B1. PLEASE HELP.
Thanks in advance for anything from anyone!