I have 2 columns with data in …column M and column N
Within column N, there are a number of cells with prices andsome cells containing the text “Check Website).
Within column M, there are a number of cells some withPrices and some are blank cells.
What I am trying to incorporate is an IF statement whichlooks at Column M and Column N. The ifstatement for column N is as follows
=IF(N2="Check Website", "",N2)
The statement returns a value if the cell doesn’t includethe text “Check Website”.
How do I incorporate this if statement to look for availabledata in column M if the cell doesn’t equal to blank?
Within column N, there are a number of cells with prices andsome cells containing the text “Check Website).
Within column M, there are a number of cells some withPrices and some are blank cells.
What I am trying to incorporate is an IF statement whichlooks at Column M and Column N. The ifstatement for column N is as follows
=IF(N2="Check Website", "",N2)
The statement returns a value if the cell doesn’t includethe text “Check Website”.
How do I incorporate this if statement to look for availabledata in column M if the cell doesn’t equal to blank?