excel if formula

		Microsoft Office Forums > Microsoft Excel > Excel
excel if formula

FAQ

Thread Tools

Display Modes

03-06-2017, 07:14 AM

HannaMM

Windows 7 32bit excel if formula

Office 2010 32bit

Novice

Join Date: Mar 2017

Posts: 1

Try this IF function

Questions: I am looking to do an if function formula for the if this 8:30 is over 8:00 then this 8.50 should be 8.00

Try This:

=IF(8:30/8:00, 8:00)

You can use relative cell reference for the first argument if there are rows and columns you want to input.

Also, make sure the number type is set to time! Home tab - Number Group - drop down arrow - time

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Formula Help??	Jainam_Excel	Excel	1	10-03-2016 03:43 PM
Excel Formula Bar	powrus1	Excel	4	07-19-2016 09:19 AM
Excel formula help please!	dreamer1963	Excel	2	03-16-2014 03:59 AM
Excel Formula	oRie	Excel	2	02-28-2012 07:48 PM
Excel Formula Help	masoom84	Excel	1	03-07-2009 09:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:25 AM.