OMG! Thanks, I'll try it.
"Bob Phillips" wrote in message
...
"Florida Flamingo" wrote in message
. ..
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
=IF(AND(A2=--"13:00:00",A2<=--"19:00:00"),"Yes","No")
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.
=IF(ISNUMBER(D1),D1,IF(ISNUMBER(D2),D2,IF(ISNUMBER (D3),D3,"")))
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.
=IF(ISNUMBER(D1),D1,IF(ISNUMBER(D2),D2,IF(ISNUMBER (D3),D3,0)))*2080
4. If a value is "no" print D4 in D5, but if the value is "yes" print D2
value multiplied by 2080 in D5
=IF(E1="no",D4,IF(E1="yes",D2*2080,""))
|