IF and OR

hsandeep

Well-known Member
Joined
Dec 6, 2008
Messages
959
Office Version
  1. 2007
Platform
  1. Windows
I want to use IF function for
=IF(CB3=1 OR BM3>0,Answer1,Answer2).
How to accomplish?
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

hsandeep

Well-known Member
Joined
Dec 6, 2008
Messages
959
Office Version
  1. 2007
Platform
  1. Windows
Thanks. But please bear with me little bit more.
I am using formula
=IF(AND(CB3=1,AI3>0),CC3-L3,IF(AI3>0,BM3-L3,IF(BM3<2,0,ROUND(BM3,0))))
In above, at the end, I want IF CB3=1 AND ALSO AI3=0, then only CC3.
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
Thanks. But please bear with me little bit more.
I am using formula
=IF(AND(CB3=1,AI3>0),CC3-L3,IF(AI3>0,BM3-L3,IF(BM3<2,0,ROUND(BM3,0))))
In above, at the end, I want IF CB3=1 AND ALSO AI3=0, then only CC3.

Formulas are not a good device for describing a problem; words are better. Would you explain it in words?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,411
Messages
5,571,954
Members
412,428
Latest member
erino
Top