Microsoft Office Forums - View Single Post - [Solved] If statement question

Thread: [Solved] If statement question

View Single Post

Old

06-04-2014, 10:09 AM

mbesspiata mbesspiata is offline

mbesspiata is offline

mbesspiata uses Windows 7 64bit

Windows 7 64bit mbesspiata uses Office 2010 64bit

mbesspiata uses Office 2010 64bit

Office 2010 64bit

Advanced Beginner

The original poster

Join Date: Mar 2011

Location: Virginia

Posts: 57

mbesspiata is on a distinguished road

Default

I just tried this formula and it works to show me the LOW but the HIGH is not working.
=IF(E3=1,"LOW",IF(E3=MAX(E:E),"HIGH")). For all rows excet the LOW it get the #N/A.
Mike

Reply With Quote