Complete Newbie query

Occasional Visitor

Never really used spreadsheets effectively other than for basic table/data input and never been taught how to use functions.

I have a simple query. I have two cells, two different values in each cell. If both meet certain criteria, I want a third cell to show result. I want Cell 3 to show N/A only if Cell 1 and Cell 2 are complete as below

Cell 1              Cell 2            Cell 3

DR-N/A          DP-N/A         N/A

How do I achieve this.

MTIA

2 Replies

@flatfoot471 

=IF(AND(Cell1<>"",Cell2<>""),"N/A","")

Hi @flatfoot471 

 

this can be done with a combination of IF and AND-function:

 

=IF(AND(A2="DR-N/A",B2="DP-N/A"),"N/A","")

Martin_Weiss_0-1658753129788.png

So only if both criteria are met, then cell C2 will show N/A, otherwise it will be empty.