If cell equals this and this cell contains this, return this

[Vihral]

Hi,

In the examplefile under Presentation I want to achieve the following.

In A4 I want a formula that checks IF Cell C4 in the Calc Sheet Equals the text I have written in B2 in Presentation Sheet and check if the cell E4 in the calc sheet has a 1 in it. IF both are true, I want the returned value to be the text writtein in A4 in the calc sheet. and if they are false, write a "NO".

I hope this makes sense. Thank you in advance!

[Pete_UK]

You can use this formula in cell A4 of the Presentation sheet:

=IF(AND(B2=Calc!C4,Calc!E4=1),Calc!A4,"NO")

Hope this helps.

Pete

EDIT: As you are in Sweden, you may need to use semicolons ( ; ) in the formula rather than commas ( , ), depending on your regional settings.

Pete

[jindon]

Perhaps
=IF(AND(B2=Calc!C4,Calc!E4=1),Calc!A4,"NO")

[Vihral]

And that does exactly what I wanted, thank you for the quick replies! Marking as Solved, giving rep, thank you!

[AliGW]

Why did you post to the VBA section f you wanted a formula?