Formula
=IF((R5<=$R$11),"5 days service",("delayed"))

The cell R5 is the result of a simple formula.
When the 'true' condition of the formula = True then it displays correctly.
When the 'false' condition of the formula = False then it displays ONLY the
true result.
If the result of R5 is typed in manually, that is not obtained from a
formula it will infact display as it should.

R S T

Service Days On Time Appt. Score in Service
ROW4 05 06:00 00 01:00 5 days service
ROW5 06 15:00 yes 5 days service
ROW6 05 09:00 00 04:00 5 days service
ROW7 05 00:00 00 01:00 5 days service



R11 - 05 12:00

I just tested your formula with the proper results. However,
=IF((R5<=$R$11),"5 days service",("delayed"))
you don't need all the ()
=IF(R5<=$R$11,"5 days service","delayed")

Don Guillett
SalesAid Software

"Titanium" wrote in message
...
Formula
=IF((R5<=$R$11),"5 days service",("delayed"))

The cell R5 is the result of a simple formula.
When the 'true' condition of the formula = True then it displays
correctly.
When the 'false' condition of the formula = False then it displays ONLY
the
true result.
If the result of R5 is typed in manually, that is not obtained from a
formula it will infact display as it should.

R S T

Service Days On Time Appt. Score in Service
ROW4 05 06:00 00 01:00 5 days service
ROW5 06 15:00 yes 5 days service
ROW6 05 09:00 00 04:00 5 days service
ROW7 05 00:00 00 01:00 5 days service



R11 - 05 12:00

Don, although your formula did work, and of course minimize any unnecessary
typing, my problem still exists. I believe it may be in the formatting of the
cell for some reason... When i manually type "06 15:00" the formula works.
Even though the result is the same when performed via Excel calculation the
result of the "IF formula" ALWAYS meets the true(5 day services) condition of
the formula, never the false(Delayed).

Thanks for any and all help you can provide.

"Don Guillett" wrote:

I just tested your formula with the proper results. However,
=IF((R5<=$R$11),"5 days service",("delayed"))
you don't need all the ()
=IF(R5<=$R$11,"5 days service","delayed")

Don Guillett
SalesAid Software

"Titanium" wrote in message
...
Formula
=IF((R5<=$R$11),"5 days service",("delayed"))

The cell R5 is the result of a simple formula.
When the 'true' condition of the formula = True then it displays
correctly.
When the 'false' condition of the formula = False then it displays ONLY
the
true result.
If the result of R5 is typed in manually, that is not obtained from a
formula it will infact display as it should.

R S T

Service Days On Time Appt. Score in Service
ROW4 05 06:00 00 01:00 5 days service
ROW5 06 15:00 yes 5 days service
ROW6 05 09:00 00 04:00 5 days service
ROW7 05 00:00 00 01:00 5 days service



R11 - 05 12:00

TTT Please

"Titanium" wrote:

Don, although your formula did work, and of course minimize any unnecessary
typing, my problem still exists. I believe it may be in the formatting of the
cell for some reason... When i manually type "06 15:00" the formula works.
Even though the result is the same when performed via Excel calculation the
result of the "IF formula" ALWAYS meets the true(5 day services) condition of
the formula, never the false(Delayed).

Thanks for any and all help you can provide.

"Don Guillett" wrote:

I just tested your formula with the proper results. However,
=IF((R5<=$R$11),"5 days service",("delayed"))
you don't need all the ()
=IF(R5<=$R$11,"5 days service","delayed")

Don Guillett
SalesAid Software

"Titanium" wrote in message
...
Formula
=IF((R5<=$R$11),"5 days service",("delayed"))

The cell R5 is the result of a simple formula.
When the 'true' condition of the formula = True then it displays
correctly.
When the 'false' condition of the formula = False then it displays ONLY
the
true result.
If the result of R5 is typed in manually, that is not obtained from a
formula it will infact display as it should.

R S T

Service Days On Time Appt. Score in Service
ROW4 05 06:00 00 01:00 5 days service
ROW5 06 15:00 yes 5 days service
ROW6 05 09:00 00 04:00 5 days service
ROW7 05 00:00 00 01:00 5 days service



R11 - 05 12:00

If you type 06 15:00 in a cell, Excel will take this to be a text
string, but the comparison in your IF statement will be looking for
numbers. Is your input meant to represent 6 days and 15 hours?

Pete

On May 29, 12:34 am, Titanium
wrote:
TTT Please



"Titanium" wrote:
Don, although your formula did work, and of course minimize any unnecessary
typing, my problem still exists. I believe it may be in the formatting of the
cell for some reason... When i manually type "06 15:00" the formula works.
Even though the result is the same when performed via Excel calculation the
result of the "IF formula" ALWAYS meets the true(5 day services) condition of
the formula, never the false(Delayed).

Thanks for any and all help you can provide.

"Don Guillett" wrote:

I just tested your formula with the proper results. However,
=IF((R5<=$R$11),"5 days service",("delayed"))
you don't need all the ()
=IF(R5<=$R$11,"5 days service","delayed")

Don Guillett
SalesAid Software

"Titanium" wrote in message
...
Formula
=IF((R5<=$R$11),"5 days service",("delayed"))

The cell R5 is the result of a simple formula.
When the 'true' condition of the formula = True then it displays
correctly.
When the 'false' condition of the formula = False then it displays ONLY
the
true result.
If the result of R5 is typed in manually, that is not obtained from a
formula it will infact display as it should.

R S T

Service Days On Time Appt. Score in Service
ROW4 05 06:00 00 01:00 5 days service
ROW5 06 15:00 yes 5 days service
ROW6 05 09:00 00 04:00 5 days service
ROW7 05 00:00 00 01:00 5 days service

R11 - 05 12:00- Hide quoted text -

- Show quoted text -

Yes, I understand that it is a string rather than a numeric... but that is
the problem. When I type the string, the formula works. Which makes no
logical sense to me...
When the numeric data that is obtained from another formula 'does it's
thing' and is then used in this formula... It doesn't work as it should.

Yes, 06 15:00 is 6 days and 15:00 Hours.

"Pete_UK" wrote:

If you type 06 15:00 in a cell, Excel will take this to be a text
string, but the comparison in your IF statement will be looking for
numbers. Is your input meant to represent 6 days and 15 hours?

Pete

On May 29, 12:34 am, Titanium
wrote:
TTT Please



"Titanium" wrote:
Don, although your formula did work, and of course minimize any unnecessary
typing, my problem still exists. I believe it may be in the formatting of the
cell for some reason... When i manually type "06 15:00" the formula works.
Even though the result is the same when performed via Excel calculation the
result of the "IF formula" ALWAYS meets the true(5 day services) condition of
the formula, never the false(Delayed).

Thanks for any and all help you can provide.

"Don Guillett" wrote:

I just tested your formula with the proper results. However,
=IF((R5<=$R$11),"5 days service",("delayed"))
you don't need all the ()
=IF(R5<=$R$11,"5 days service","delayed")

Don Guillett
SalesAid Software

"Titanium" wrote in message
...
Formula
=IF((R5<=$R$11),"5 days service",("delayed"))

The cell R5 is the result of a simple formula.
When the 'true' condition of the formula = True then it displays
correctly.
When the 'false' condition of the formula = False then it displays ONLY
the
true result.
If the result of R5 is typed in manually, that is not obtained from a
formula it will infact display as it should.

R S T

Service Days On Time Appt. Score in Service
ROW4 05 06:00 00 01:00 5 days service
ROW5 06 15:00 yes 5 days service
ROW6 05 09:00 00 04:00 5 days service
ROW7 05 00:00 00 01:00 5 days service

R11 - 05 12:00- Hide quoted text -

- Show quoted text -