3 values How to return different value?

[springran]

[TABLE="width: 500"]
<tbody>[TR]
[TD]product code
[/TD]
[TD]Jan price
[/TD]
[TD]Feb price
[/TD]
[TD]MAR PRICE
[/TD]
[TD]% / Different
[/TD]
[/TR]
[TR]
[TD]132
[/TD]
[TD]10
[/TD]
[TD]10
[/TD]
[TD]11
[/TD]
[TD]??
[/TD]
[/TR]
[TR]
[TD]399
[/TD]
[TD]12
[/TD]
[TD]12
[/TD]
[TD]12
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]398
[/TD]
[TD]9
[/TD]
[TD]8
[/TD]
[TD]15
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Hi All
I have some sales data.As the table above.
I would like to see if price same for 3 month it shows "nothing" in the last column. if price are different shows how much increase / decrease would be or shows % of increase / decrease.

Thank you in advances

Spring

 

[sadath]

=IF(AND(B2=C2,C2=D2),"nothing",TEXT(D2/B2-1,"#%"))
% increase/decrease is Mar Price over Jan Price, if not change the formula accordingly

 

[sandy666]

maybe =IF(MAX(B2:D2)/MIN(B2:D2)=1,"nothing",MAX(B2:D2)/MIN(B2:D2)-1)

or
=IFERROR(IF(MAX(B4:D4)/MIN(B4:D4)=1,"nothing",MAX(B4:D4)/MIN(B4:D4)-1),MAX(B4:D4)/SMALL(B4:D4,2)-1) against #DIV/0!

 

[sandy666]

=IFERROR(IFERROR(IF(MAX(B4:D4)=MIN(B4:D4),"nothing",MAX(B4:D4)/MIN(B4:D4)-1),MAX(B4:D4)/SMALL(B4:D4,2)-1),MAX(B4:D4)/MAX(B4:D4))

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]product code[/td][td=bgcolor:#5B9BD5]Jan price[/td][td=bgcolor:#5B9BD5]Feb price[/td][td=bgcolor:#5B9BD5]MAR PRICE[/td][td=bgcolor:#5B9BD5]%[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]

132​

[/td][td=bgcolor:#DDEBF7]

10​

[/td][td=bgcolor:#DDEBF7]

10​

[/td][td=bgcolor:#DDEBF7]

11​

[/td][td=bgcolor:#DDEBF7]

10%​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

399​

[/td][td]

12​

[/td][td]

12​

[/td][td]

12​

[/td][td]nothing[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]

398​

[/td][td=bgcolor:#DDEBF7]

9​

[/td][td=bgcolor:#DDEBF7]

8​

[/td][td=bgcolor:#DDEBF7]

15​

[/td][td=bgcolor:#DDEBF7]

88%​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

222​

[/td][td]

9​

[/td][td]

0​

[/td][td]

15​

[/td][td]

67%​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]

223​

[/td][td=bgcolor:#DDEBF7]

0​

[/td][td=bgcolor:#DDEBF7]

0​

[/td][td=bgcolor:#DDEBF7]

15​

[/td][td=bgcolor:#DDEBF7]

100%​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

224​

[/td][td]

0​

[/td][td]

0​

[/td][td]

0​

[/td][td]nothing[/td][/tr]
[/table]

 

[springran]

Thanks

 

[sandy666]

You're welcome