|
|
#1
06-06-2023, 11:16 AM
|
|||
|
|||
#value! Error
Keep getting this error. I want column D to remain blank till there is an entry in in column C on same row. What am I missing???
|
|
#2
06-06-2023, 11:59 AM
|
|||
|
|||
|
When the cell C14 is blank, your formula =IF(C14="","",C14-B14)*1440 evaluates to [blank] * 1440 which cannot be resolved.
Did you mean to write =IF(C14="","",(C14-B14)*1440) ?
|
|
#3
06-06-2023, 12:31 PM
|
|||
|
|||
|
Not sure if that what i meant to write, but it works.
Thanks for the come back.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 error handler: inserting building blocks when multiple cells in a table are selected creates error
|
LSLSLS | Word VBA | 2 | 01-07-2022 05:46 AM |
| Suddenly having trouble using .Refresh BackgroundQuery. Error 1004, General ODBC Error | PLSBRYDOBOY | Excel Programming | 0 | 08-30-2019 12:17 PM |
|
Automation error Unknown error" message once they open the Excel file
|
hlina | Excel | 1 | 10-08-2013 09:14 PM |
|
Microsoft office 2010 error 2908 and error 1935 !!!!!!heeeeellpppp!!!!!!!!!
|
bennypryde | Office | 1 | 01-05-2012 03:33 PM |
| Runtime error 5487 - Word cannot complete the save to to file permission error | franferns | Word | 0 | 11-25-2009 05:35 AM |
Windows 7 32bit 
Office 2007
Linear Mode
