Hi all

Just need some help with an if formula

if B1 = A1 then i want it to display "Same", otherwise if it is higher
then display "Higher", if lower then display "Lower", if there is
nothing in A1 and a figure in B1 then i would like it to display "New
Price"

Thanks
Andrew


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=521967