Need help w/ IF function that has multiple exceptions!

		Microsoft Office Forums > Microsoft Excel > Excel
Need help w/ IF function that has multiple exceptions!

08-17-2016, 11:10 PM

Green Crocodile Green Crocodile is offline

Windows 7 32bit Need help w/ IF function that has multiple exceptions!

Office 2010 32bit

Novice

Join Date: Aug 2016

Posts: 1

use and AND function

=if(and(or(a1=1, a1=2, a1=3),b1<>10), c1, 0)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word Autocorrect exceptions not working.	Spotofpaint	Word	0	10-23-2014 06:14 PM
Autocorrect Exceptions not working	danvdr	Word	6	05-26-2014 09:37 PM
multiple conditions, and blank cells with the countifs function	jaden0605	Excel	1	03-30-2014 01:50 AM
Tabbing in tables in exceptions to protected form	jsr	Word	2	09-17-2013 01:29 AM
Exceptions for 'Capitalize first letter of sentences'	gazpacho	Word	1	01-12-2012 11:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:40 AM.