|
|
#1
08-17-2016, 05:22 PM
|
|||
|
|||
Need help w/ IF function that has multiple exceptions!
Dear Excel Gurus...
I have a bunch of data that I need to divide into different categories (columns). Is there any way that I can create a formula where it would take into account that IF column A is equal to 1, 2, or 3 (for example), AND column B does NOT equal 10, I can get the value in column C? For now I'm using: IF(OR(A1=1, A1=2, A1=3), C1, 0), but I'm not sure how to incorporate the part about column B in there. Thank you!! 
|
|
#2
08-17-2016, 11:10 PM
|
|||
|
|||
|
use and AND function
=if(and(or(a1=1, a1=2, a1=3),b1<>10), c1, 0)
|
|
#3
06-11-2018, 01:53 AM
|
|||
|
|||
|
What value you want in column C if you want A1 value then follow below
=IF(OR(AND(A1=1,A1=2,A1=3),B1<>10),A1,0) if you want B1 value then follow below =IF(OR(AND(A1=1,A1=2,A1=3),B1<>10),B1,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 |
Windows 7 64bit 
Office 2016
Linear Mode
