Forum Discussion
Complete Newbie query
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 cel...
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.