marreco
Well-known Member
- Joined
- Jan 1, 2011
- Messages
- 609
- Office Version
- 2010
- Platform
- Windows
Hi.
I need a function that returns me the approximate value and not the exact value.
example:
<tbody>
</tbody>
33 if I type in 'B1' and my mother I'm 33 and I have a number near and less than the number entered in 'B1' will be returned 32
thank you!!
I need a function that returns me the approximate value and not the exact value.
example:
Number | value next sought | result |
3 | 33 | 32 |
2 | ||
6 | ||
32 | ||
33 | ||
45 |
<tbody>
</tbody>
33 if I type in 'B1' and my mother I'm 33 and I have a number near and less than the number entered in 'B1' will be returned 32
thank you!!