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

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to deduct a figure the sum of two cells is equal to or greater than a certain valu

11-24-2017, 06:15 AM

NBVC

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

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

try...

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't figure out a formula - Vlookup or something else?	Redsox	Excel	3	08-25-2017 08:54 AM
formula using equals/greater than etc signs	msnarayanan	Excel	2	02-25-2016 08:21 AM
Need help with excel formula greater than..	bm868	Excel	2	01-02-2016 10:29 AM
Automatically change the value of one cell so that two other cells become equal	matthew544	Excel	5	09-18-2011 08:56 AM
If A1 greater than or equal to 1 Then A3 = A2*A1	brians	Excel	5	03-09-2010 12:04 PM

Other Forums: Access Forums

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