IF statement with Multiple condition

[Sushiboy]

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?

 

[DanteAmor]

Try this

=IF(M2="",IF(N2="Check Website", "",N2),M2)

 

[Sushiboy]

Thank you Dante. that worked.

I have another question

Column (H) has various prices and column (M) has some blankcells and some prices.
How would I write the IF function to
Select Column M Prices providing they are available? If column M prices are notavailable, I want to select column H prices
thankyou

 

[soadfan]

Or you can use AND() NOT() ISBLANK() in the condition
Something like =IF(AND(NOT(ISBLANK(M2)), N2="Check Website"),N2,M2)

EDIT for H and M:
=IF(ISBLANK(M2),H2,M2)

 

[Sushiboy]

Many thanks Soadfan