Microsoft Office Forums - View Single Post - formula using equals/greater than etc signs

Thread: formula using equals/greater than etc signs

View Single Post

Old

02-25-2016, 06:56 AM

sdrawkcab

sdrawkcab is offline

sdrawkcab uses Windows 7 32bit

Windows 7 32bit sdrawkcab uses Office 2003

sdrawkcab uses Office 2003

Office 2003

Novice

Join Date: Dec 2015

Posts: 4

sdrawkcab is on a distinguished road

Default

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

Reply With Quote