Microsoft Office Forums - View Single Post - [Solved] Excel--Help!!

Thread: [Solved] Excel--Help!!

View Single Post

Old

09-04-2013, 06:16 AM

Gary Drumm Gary Drumm is offline

Gary Drumm is offline

Gary Drumm uses Windows XP

Windows XP Gary Drumm uses Office 2007

Gary Drumm uses Office 2007

Office 2007

Advanced Beginner

Join Date: Mar 2012

Posts: 86

Gary Drumm is on a distinguished road

Default

This works (I moved everything down one row to allow for titles)
my E2=IF(B2>2,"fail","pass")
my E3=IF(B3>4,"fail","pass")
my E4=IF(B4>10,"fail","pass")
my E5=IF(B5>16,"fail","pass")

Reply With Quote