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

"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,""))

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,""))

As I worked this sheet further down, I came across another function that I
couldn't forsee. Can anyone be of help here.


AH21 = 29,000
or
AH21 = "N/A"


AH24 = "yes"
AH24 = "no"



Need this in one statement
===========================
If AH24 = "yes" "do message"
If AH24 = "no" add 4,000 to AH21

(Can cause #value error here if AH21 = "n/a")

=====================================
END




"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,""))

Not sure on this one as to what exactly you mean, but give it a shot

=IF(AH24="yes","do message",IF(AH24="no",IF(AH21="N/A",AH21,AH21+4000),""))

--
HTH

Bob Phillips

"Florida Flamingo" wrote in message
. ..
As I worked this sheet further down, I came across another function that I
couldn't forsee. Can anyone be of help here.


AH21 = 29,000
or
AH21 = "N/A"


AH24 = "yes"
AH24 = "no"



Need this in one statement
===========================
If AH24 = "yes" "do message"
If AH24 = "no" add 4,000 to AH21

(Can cause #value error here if AH21 = "n/a")

=====================================
END




"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,""))

WOW, you're fantastic. That did it. Since I used the exact cell
references, I just cut-n-pasted and held my breath. It worked. I just
changed the "do message".

It's a chart to calculate a wage increase when promoting someone from hourly
to a management training program or hiring in an experienced external
candidate. The issue that made it hard was that hourly promotes are usually
at a lower wage during training and then receive a bonus after graduation,
while an external candidate is brought into the company at a much higher
rate, therefore not receiving a bonus for training.

Thank you very much. You've made a complicated chart user friendly for a
lot of us.
- Genie



"Bob Phillips" wrote in message
...
Not sure on this one as to what exactly you mean, but give it a shot

=IF(AH24="yes","do
message",IF(AH24="no",IF(AH21="N/A",AH21,AH21+4000),""))

--
HTH

Bob Phillips

"Florida Flamingo" wrote in message
. ..
As I worked this sheet further down, I came across another function that
I
couldn't forsee. Can anyone be of help here.


AH21 = 29,000
or
AH21 = "N/A"


AH24 = "yes"
AH24 = "no"



Need this in one statement
===========================
If AH24 = "yes" "do message"
If AH24 = "no" add 4,000 to AH21

(Can cause #value error here if AH21 = "n/a")

=====================================
END




"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,""))

How could I refuse a Florida flamingo :-)

Bob

"Florida Flamingo" wrote in message
. ..
WOW, you're fantastic. That did it. Since I used the exact cell
references, I just cut-n-pasted and held my breath. It worked. I just
changed the "do message".

It's a chart to calculate a wage increase when promoting someone from
hourly
to a management training program or hiring in an experienced external
candidate. The issue that made it hard was that hourly promotes are
usually
at a lower wage during training and then receive a bonus after graduation,
while an external candidate is brought into the company at a much higher
rate, therefore not receiving a bonus for training.

Thank you very much. You've made a complicated chart user friendly for a
lot of us.
- Genie



"Bob Phillips" wrote in message
...
Not sure on this one as to what exactly you mean, but give it a shot

=IF(AH24="yes","do
message",IF(AH24="no",IF(AH21="N/A",AH21,AH21+4000),""))

--
HTH

Bob Phillips

"Florida Flamingo" wrote in message
. ..
As I worked this sheet further down, I came across another function
that
I
couldn't forsee. Can anyone be of help here.


AH21 = 29,000
or
AH21 = "N/A"


AH24 = "yes"
AH24 = "no"



Need this in one statement
===========================
If AH24 = "yes" "do message"
If AH24 = "no" add 4,000 to AH21

(Can cause #value error here if AH21 = "n/a")

=====================================
END




"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,""))