I need advice on what function I need in the following scenarios.


1. Is the value in A2 between 13.00 and 19.00 If true print Yes in B2, if
false print No in B2

======================================
Ex:
A1="no"
B1=270
C1="n/a"


2. I need to check the numerical value in 3 cells. Only one will have a
numerical value, and I want to print that value in C2.

3. I need to check the numerical value in 3 cells. Only one will have a
numerical value, and I want to take that value and multiply by 2080 and
print in D2.

=======================================
I think this is similar to #3 above.

4. If a value is "no" print D4 in D5, but if the value is "yes" print D2
value multiplied by 2080 in D5

TIA