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. |
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. |
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