Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-06-2023, 11:16 AM
Trapshooter1956 Trapshooter1956 is offline #value! Error Windows 7 32bit #value! Error Office 2007
Advanced Beginner
#value! Error
 
Join Date: Mar 2017
Posts: 31
Trapshooter1956 is on a distinguished road
Default #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???
Attached Files
File Type: xlsx Reedbed Watering Data.xlsx (20.8 KB, 1 views)
Reply With Quote
  #2  
Old 06-06-2023, 11:59 AM
MartinGM MartinGM is offline #value! Error Windows 11 #value! Error Office 2021
Advanced Beginner
 
Join Date: May 2023
Location: England
Posts: 66
MartinGM is on a distinguished road
Default

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) ?
Reply With Quote
  #3  
Old 06-06-2023, 12:31 PM
Trapshooter1956 Trapshooter1956 is offline #value! Error Windows 7 32bit #value! Error Office 2007
Advanced Beginner
#value! Error
 
Join Date: Mar 2017
Posts: 31
Trapshooter1956 is on a distinguished road
Default

Not sure if that what i meant to write, but it works.
Thanks for the come back.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
#value! Error 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
#value! Error Automation error Unknown error" message once they open the Excel file hlina Excel 1 10-08-2013 09:14 PM
#value! Error 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:45 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft