multiple logical tests in an IF function

[Priscilla]

I would like to automate a spreadsheet using 2 logical
tests; basically something like this:

IF ((B3="text") AND (C3="text"),$00.00,0)

I know that doesn't work, but I think it should. Can
someone help me with this?? I'm trying to assign a dollar
value using two sets of criteria.

Thanks

 

[Kevin Stecyk]

Priscilla,

You are very close.

=IF(and((B3="text"),(C3="text")),$00.00,0)

HTH

Regards,
Kevin

 

[Chip Pearson]

Priscilla,

Try something like the following:

=IF(AND(B3="text",C3="text"),TRUE,FALSE)

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Ken Wright]

=IF(AND(ISTEXT(A1),ISTEXT(B1)),999,0)

or

=IF(AND(ISTEXT(A1:B1)),999,0) array entered using CTRL+SHIFT+ENTER

Replace 999 with whatever your values if true are

 

[Kevin Stecyk]

Priscilla,

Upon further reflection, both the true and false will give you the same
answer: 0. The formatting of the cell will dictate how it is displayed. Is
that what you want? It appears to be you will get a 0 regardless.

Perhaps this?

=IF(and((B3="text"),(C3="text")),$00.00,"")

Now if it is false, you will get a blank cell.

Regards,
Kevin

 

[Ken Wright]

hehe - kinda read that one wrong I think - Chip and Kevin have what you need.