Microsoft Office Forums - View Single Post - [Solved] #value! Error

Thread: [Solved] #value! Error

View Single Post

Old

06-06-2023, 11:59 AM

MartinGM

MartinGM is offline

MartinGM uses Windows 11

Windows 11 MartinGM uses Office 2021

MartinGM uses Office 2021

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