whats wrong with this formula

[Trilogist]

[COLOR=#1F497D][FONT=Calibri]=IF((OR('Wk 1'!$E6="Mortgage",'Wk 1'!$E6="re-mortgage",'Wk 1'!$E6="re-mortgage PED")),IF((OR('Wk 1'!$F6="EA",'Wk 1'!$F6="Lettings")),"",'Wk 1'!$C6)," ")[/FONT][/COLOR]

I am trying to get the cell to display the contents of C6 or return blank IF a combination of E6 equal to 'Mortgage' 're-mortgage' 're-mortgage ped AND IF F6 is equal to 'EA' or 'Lettings'. At the moment the cell returns blank every time.

Hope this makes sense.

 

[Dryver14]

=IF((OR('Wk 1'!$E6="Mortgage",'Wk 1'!$E6="re-mortgage",'Wk 1'!$E6="re-mortgage PED")),IF((OR('Wk 1'!$F6="EA",'Wk 1'!$F6="Lettings")),'Wk 1'!$C6)," ")

I think there were 2 sets of "" at the end try this

 

[StephenCrump]

I think there were 2 sets of "" at the end try this

You'll need them to suppress the FALSE if the second condition is not met:

=IF(OR('Wk 1'!$E6="Mortgage",'Wk 1'!$E6="re-mortgage",'Wk 1'!$E6="re-mortgage PED"),IF((OR('Wk 1'!$F6="EA",'Wk 1'!$F6="Lettings")),'Wk 1'!$C6,""),"")

The original post just had them around the wrong way, i.e. "",'Wk 1'!$C6 rather than 'Wk 1'!$C6,""

 

[Trilogist]

You'll need them to suppress the FALSE if the second condition is not met:

=IF(OR('Wk 1'!$E6="Mortgage",'Wk 1'!$E6="re-mortgage",'Wk 1'!$E6="re-mortgage PED"),IF((OR('Wk 1'!$F6="EA",'Wk 1'!$F6="Lettings")),'Wk 1'!$C6,""),"")

The original post just had them around the wrong way, i.e. "",'Wk 1'!$C6 rather than 'Wk 1'!$C6,""

Thank you very much. I love this place.