Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Currency formula/formatting problem | Excel Discussion (Misc queries) | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
Conditional formatting with dates formula problem. | Excel Discussion (Misc queries) |