ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   IF "A" is TRUE and "B" is TRUE? (https://www.excelbanter.com/excel-discussion-misc-queries/111242-if-true-b-true.html)

ConfusedNHouston

IF "A" is TRUE and "B" is TRUE?
 
I want to write an IF statement that looks at values in 2 cells. Basically
if D2=0 and D3="", then Enter "GOOD", "NO")

I can't figure out how to get the IF statement to look at values in both
cells.

Thanks.

Marcelo

IF "A" is TRUE and "B" is TRUE?
 
hi

=if(and(d2=0,d3=""),"Good","No")

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"ConfusedNHouston" escreveu:

I want to write an IF statement that looks at values in 2 cells. Basically
if D2=0 and D3="", then Enter "GOOD", "NO")

I can't figure out how to get the IF statement to look at values in both
cells.

Thanks.


bigwheel

IF "A" is TRUE and "B" is TRUE?
 
Hi, try =IF(AND(D2=0,D3=""),"Good","No")

"ConfusedNHouston" wrote:

I want to write an IF statement that looks at values in 2 cells. Basically
if D2=0 and D3="", then Enter "GOOD", "NO")

I can't figure out how to get the IF statement to look at values in both
cells.

Thanks.



All times are GMT +1. The time now is 04:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com