capricorn123
New Member
- Joined
- Jul 24, 2019
- Messages
- 4
Mr (or Ms) Excel Community,
I need your help to figure out the formula as I hit the roadblock.
I used the following formula to come up with the reporting liters value of the below table:
=IF(AND(B4>=D2,B4<=E2),C2)*B3
The outcome I am trying to achieve that we manually input gallons value (B2) and Brix value (B4). It will lookup column D & E and if Brix value falls between any of those ranges from D2 to E13, it will relatively pick column C value and times it by Liters (B3) and give us the reporting liters value.
e.g. If I enter brix value (B4) 41.7 it will automatically pick 3.5 (row6) and times it with Liters (B3) so we can get Reporting Liters value.
PS: any Brix value less than 19.46 should pick "1" and any value greater than 70.07 should pick "C13".
<tbody>
</tbody>
Fingers Crossed and thank you for your help in advance!!
I need your help to figure out the formula as I hit the roadblock.
I used the following formula to come up with the reporting liters value of the below table:
=IF(AND(B4>=D2,B4<=E2),C2)*B3
The outcome I am trying to achieve that we manually input gallons value (B2) and Brix value (B4). It will lookup column D & E and if Brix value falls between any of those ranges from D2 to E13, it will relatively pick column C value and times it by Liters (B3) and give us the reporting liters value.
e.g. If I enter brix value (B4) 41.7 it will automatically pick 3.5 (row6) and times it with Liters (B3) so we can get Reporting Liters value.
PS: any Brix value less than 19.46 should pick "1" and any value greater than 70.07 should pick "C13".
<tbody> </tbody> |
<tbody>
</tbody>
Fingers Crossed and thank you for your help in advance!!