| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to substitute formula result from #### to"CHECK YOUR ENTRY"
I have a results cell that adds total time worked minus meal time.
excel displays negative time as ####. How can I amend the formula to change #### to show "CHECK YOUR ENTRY" |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need to substitute formula result from #### to"CHECK YOUR ENTRY"
perhaps:
=IF(total time meal time, total time - meal time, "CHECK YOUR ENTRY") "Trevor" wrote: I have a results cell that adds total time worked minus meal time. excel displays negative time as ####. How can I amend the formula to change #### to show "CHECK YOUR ENTRY" |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need to substitute formula result from #### to"CHECK YOUR ENTRY"
=IF(A2-B2<0,"CHECK YOUR ENTRY",A2-B2)
-- David Biddulph "Trevor" wrote in message ... I have a results cell that adds total time worked minus meal time. excel displays negative time as ####. How can I amend the formula to change #### to show "CHECK YOUR ENTRY" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula entry using "+" causing format errors | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
| How do I replace a "#N/A" formula result with a blank in excel? | Excel Discussion (Misc queries) | |||
| =countif (h3:h16"=01 01 2006") how to substitute cell for date | Excel Worksheet Functions | |||
Linear Mode
