If statement question

		Microsoft Office Forums > Microsoft Excel > Excel
If statement question

FAQ

Thread Tools

Display Modes

06-04-2014, 10:09 AM

mbesspiata mbesspiata is offline

Windows 7 64bit If statement question

Office 2010 64bit

Advanced Beginner

Join Date: Mar 2011

Location: Virginia

Posts: 57

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Add a statement	sma	Word	6	03-23-2014 10:30 AM
Question about Case statement	Jennifer Murphy	Word VBA	1	01-05-2013 02:30 PM
Help with IF Statement	limpbizkit	Excel	4	02-24-2011 09:16 PM
if statement	piper7971	PowerPoint	1	08-19-2010 07:10 AM
Help with IF statement!	CPelkey	Word	1	04-12-2010 09:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:02 PM.