ExcelBanter - need to substitute formula result from #### to"CHECK YOUR ENTRY"

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - need to substitute formula result from #### to"CHECK YOUR ENTRY" (https://www.excelbanter.com/excel-discussion-misc-queries/146259-need-substitute-formula-result-check-your-entry.html)

Trevor

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"

JMB

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"

David Biddulph[_2_]

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"

All times are GMT +1. The time now is 02:58 AM.