Basic if formula

[koba]

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

[Trevor Shuttleworth]

Andrew

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

Regards

Trevor


"koba" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>