Andrew

=IF(AND(A1="",B1<""),"New
Price",IF(B1=A1,"Same",IF(B1A1,"Higher","Lower")) )

Regards

Trevor


"koba" wrote in message
...

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