Complete Newbie query

Copper Contributor

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.


2 Replies



Hi @flatfoot471 


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




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