| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match #1, 2, 3 with "A", #1, 2, 2 with "B", and #3, 3 with "C" | Excel Discussion (Misc queries) | |||
Linear Mode
