Using If formula with multiple conditions

[anwitha]

Hi All,

I need to get the result based on the certain cellls by using If conditions. Attached the sample file. Please help.

Note : - Based on the false statement in the cell i need to get the result as mentioend in the result column

THnaks in advance!!!

[AliGW]

Please explain the expected results in H7 and H9 - they don't make sense to me.

[anwitha]

Hi,

In each column cells if there is text "false" is there i need to get the result in last column which colum is having false..

[AliGW]

That doesn't explain the expected results below (red chevrons):

Excel 2016 (Windows) 32 bit

	D	E	F	G	H	I
4	Column1	Column2	Column3	column4	Result
5	TRUE	TRUE	TRUE	TRUE	Everything is correct
6	TRUE	FALSE	FALSE	TRUE	CHANGE IN COLUMN2 & column 3
7	FALSE	TRUE	TRUE	TRUE	CHANGE IN COLUMN1 and column 4	<<<
8	TRUE	TRUE	FALSE	TRUE	CHANGE IN COLUMN3
9	TRUE	TRUE	TRUE	FALSE	CHANGE IN COLUMN	<<<
10	FALSE	FALSE	FALSE	FALSE	Everything is INcorrect
11	TRUE	FALSE	FALSE	FALSE	CHANGE IN COLUMN2, column 3 and column 4

Sheet: Sheet1

[anwitha]

please refer the below

Cell G7 should be FALSE and

result for H9 should be change in column 4.

[mehmetcik]

Paste in I5 and fill down.

Please Login or Register  to view this content.

[anwitha]

Thanks a lot for your quick solution.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.