Using multiple IF criteria

[Guest]

I've done this before but can't remember how I did it. I want to do an IF
type formula (I think) that refers to a value in another cell based on the
value in two cells. For example, B1 equals "A" and B2 equals 5%. If those two
criteria match the query, then I want the value to be what is in B3. Any
suggestions? Thanks

 

[Guest]

=if(and(b1="A",b2=.05),B3,"")

Dave

 

[Hans Knudsen]

=(B1="A")*(B2=5%)*B3
or
=IF(And(B1="A",B2=5%),B3;"")

Hans