| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel must display error message if two blocks don't have same
Yes, thank you Peo. It works.
"Peo Sjoblom" wrote: Then try =IF(B2<B3,"error message",B3-A3) -- Regards, Peo Sjoblom "Mrs Smith" wrote in message ... correspond - if two cells don't have exactly the same number, then error message. Thanks, I'm going to try your formula if this does not work I'll come back to you for more info on - Data validation "Peo Sjoblom" wrote: What do you mean by "correspond"? If one or more cells are empty? =IF(COUNT(A2:B2)=2,B2-A2,"error message") you might also want to look at datavalidation -- Regards, Peo Sjoblom "Mrs Smith" wrote in message ... Version of Excel is 97 I have two columns - Start clock and stop clock - then next column has - total in the next line if the End clock time from line before does not correspond with Start clock time. - I must get an error message. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error Message: Not enough system resources to display completely. | Excel Discussion (Misc queries) | |||
| how to display an error message | Excel Worksheet Functions | |||
| Why error message when trying to display custom view? | Excel Discussion (Misc queries) | |||
| Why error message - not enough system resources to display comple. | Excel Discussion (Misc queries) | |||
| How to display a blank cell with no error message | Excel Worksheet Functions | |||
Threaded Mode
