Microsoft Office Forums - View Single Post - [Solved] Need help w/ IF function that has multiple exceptions!

Thread: [Solved] Need help w/ IF function that has multiple exceptions!

View Single Post

Old

06-11-2018, 01:53 AM

Shashi Kant Shashi Kant is offline

Shashi Kant is offline

Shashi Kant uses Windows 7 32bit

Windows 7 32bit Shashi Kant uses Office 2016

Shashi Kant uses Office 2016

Office 2016

Novice

Join Date: May 2018

Posts: 16

Shashi Kant is on a distinguished road

Default

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)

Reply With Quote