ststern45
Well-known Member
- Joined
- Sep 17, 2005
- Messages
- 958
- Office Version
- 365
- 2010
- Platform
- Windows
I would like to know if a formula can be created for the following:
I have a value in cell A1 = 1052504
Since the value in cell A1 = 1052504 is greater than or equal to B2 (1048577) and less than or equal to C2 (2097152) the result would be 1 (cell D2).
Can a formula be created to calculate the above?
I have values in the following cells:
B1 = 0000001
C1 = 1048576
D1 = 0
B2 = 1048577
C2 = 2097152
D2 = 1
B3 = 2097153
C3 = 2704156
C3= 2
Thanks in advance.
I have a value in cell A1 = 1052504
Since the value in cell A1 = 1052504 is greater than or equal to B2 (1048577) and less than or equal to C2 (2097152) the result would be 1 (cell D2).
Can a formula be created to calculate the above?
I have values in the following cells:
B1 = 0000001
C1 = 1048576
D1 = 0
B2 = 1048577
C2 = 2097152
D2 = 1
B3 = 2097153
C3 = 2704156
C3= 2
Thanks in advance.
Last edited: