M
Mona
Hello-
My example data looks like this:
A1 B1 C1
1 4 100
5 9 200
10 12 300
In D10 I have value of 3. I would like to create formula if D10 is greater
than A1 but less than B1 then select C1. So in this example it would be 100
thanks
My example data looks like this:
A1 B1 C1
1 4 100
5 9 200
10 12 300
In D10 I have value of 3. I would like to create formula if D10 is greater
than A1 but less than B1 then select C1. So in this example it would be 100
thanks