Microsoft Office Forums - View Single Post - Formula to deduct a figure the sum of two cells is equal to or greater than a certain valu

Thread: Formula to deduct a figure the sum of two cells is equal to or greater than a certain valu

View Single Post

Old

11-24-2017, 06:15 AM

NBVC

NBVC is offline

NBVC uses Windows 10

Windows 10 NBVC uses Office 2013

NBVC uses Office 2013

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

NBVC will become famous soon enough

NBVC will become famous soon enough

Default

try...

=(D14-B14)*24-IF((D14-B14)*24>=6,0.5,0)

Reply With Quote