formula using equals/greater than etc signs

		Microsoft Office Forums > Microsoft Excel > Excel
formula using equals/greater than etc signs

02-25-2016, 06:56 AM

sdrawkcab

Windows 7 32bit formula using equals/greater than etc signs

Office 2003

Novice

Join Date: Dec 2015

Posts: 4

Try this
G9 =IF(AND(G8>=80,G8<84),30)

returns False if G8 less than 80 or G8 more than or equal to 84

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If a cell equals amount in column B.	lawnphysics	Excel Programming	1	01-16-2016 07:51 PM
Need help with excel formula greater than..	bm868	Excel	2	01-02-2016 10:29 AM
Too many email addresses equals no send	seaboyd	Outlook	0	02-23-2015 11:00 AM
Adding up cells if value equals	Kh1978	Excel	6	07-15-2014 12:48 PM
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 02:17 PM.