Jul 25 2022 05:04 AM
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
Jul 25 2022 05:46 AM - edited Jul 25 2022 05:47 AM
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","")
So only if both criteria are met, then cell C2 will show N/A, otherwise it will be empty.