if function formula from three columns or three conditions

Joko Purnomo

Board Regular
Joined
Jul 14, 2008
Messages
62
Office Version
  1. 2016
Platform
  1. Windows
First PositionSecond PositionCriteriaResult Formula
BABANot ROAG
BABAROAG
CRECRENot ROCnO
CRECREROIDB
CSCSNot ROCnO
CSCSROIDB
INTDBTSEROIDB
MAMAROIHA
MAMANot ROIHA
BCPSRBCPHNNot ROCnO

Can friends help me to make an if formula in column D (Result Formula), from different conditions for the three columns A, B, C. For example, when column A = "BA", and column B = "BA", and column C = "Not RO", then column D is "AG". Help me from row 2 to 11 in column D (Result Formula), if the condition is false from all of condition (eleven condition), then column D = "CnO".


If my friends who are experts, can volunteer to help my difficulties. Thank you very much ???
 

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,)
Try this:
Book1
ABCDE
1
2BABANot ROAG
3BABAROCnO
4CRECRENot ROCnO
5CRECREROCnO
6CSCSNot ROCnO
7CSCSROCnO
8INTDBTSEROCnO
9MAMAROCnO
10MAMANot ROCnO
11BCPSRBCPHNNot ROCnO
12
Sheet1
Cell Formulas
RangeFormula
D2:D11D2=IF((A2="BA")*(B2="BA")*(C2="Not RO"), "AG", "CnO")
 
Upvote 0
Solution
=IF((A2="BA")*(B2="BA")*(C2="Not RO"), "AG", "CnO")
thank so much, the formula has worked

=IF((A2="BA")*(B2="BA")*(C2="Not RO"),"AG",IF((A2="BA")*(B2="BA")*(C2="RO"),"AG",IF((A2="CRE")*(B2="CRE")*(C2="RO"),"IDB",IF((A2="CS")*(B2="CS")*(C2="RO"),"IDB",IF((A2="INTDB")*(B2="TSE")*(C2="RO"),"IDB",IF((A2="MA")*(B2="MA")*(C2="RO"),"IHA",IF((A2="MA")*(B2="MA")*(C2="Not RO"),"IHA","CnO")))))))
 
Upvote 0
You can Remove Column C from Criteria Because Result for you For "RO" & "Not RO" is same.
Excel Formula:
=IF((A2="BA")*(B2="BA"),"AG",IF((A2="CRE")*(B2="CRE"),IF((A2="INTDB")*(B2="TSE"),"IDB",IF((A2="MA")*(B2="MA"),"IHA","CnO"))))
 
Upvote 0
You can Remove Column C from Criteria Because Result for you For "RO" & "Not RO" is same.
Excel Formula:
=IF((A2="BA")*(B2="BA"),"AG",IF((A2="CRE")*(B2="CRE"),IF((A2="INTDB")*(B2="TSE"),"IDB",IF((A2="MA")*(B2="MA"),"IHA","CnO"))))

it's different when CS and CRE are not ro then CnO, besides RO
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,034
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top