Basic if formula

K

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
 
T

Trevor Shuttleworth

Andrew

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

Regards

Trevor
 
Top