If formulae and excluding scenario's

[Kevincfc]

Hi, sorry if the following excel question is basic but any help would be greatly appreciated.

I am currently working on a spreadsheet that comes daily, which contains prices in two rows.

So i currently have an if function (=if(a1=b1,"stalepriced'',dailypriced") that if the price in column a is the same as column b then it means that the price is ''stale priced''. Likewise if the prices in the columns are different then it would return ''daily priced''.

However the file that I receive daily never contains the same amount of rows. So as a result when I record a VBA, blank rows with no prices will give a ''stale priced'' return when there is less rows. Which is incorrect.

Is there possibly a way to amend the If formulae to take the blank cells into consideration, and exclude them?

Any help greatly appreciated.

Kevin

 

[Jonmo1]

Try
=if(or(a1="",b1=""),"",if(a1=b1,"stalepriced'',dailypriced"))

 

[Kevincfc]

Try
=if(or(a1="",b1=""),"",if(a1=b1,"stalepriced'',dailypriced"))

Works perfect. Thank you very much.

 

[Jonmo1]

You're welcome.