View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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.