3 values How to return different value?

[springran]

product code	Jan price	Feb price	MAR PRICE	% / Different
132	10	10	11	??
399	12	12	12
398	9	8	15

<tbody>
</tbody>

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))

product code	Jan price	Feb price	MAR PRICE	%
132​	10​	10​	11​	10%​
399​	12​	12​	12​	nothing
398​	9​	8​	15​	88%​
222​	9​	0​	15​	67%​
223​	0​	0​	15​	100%​
224​	0​	0​	0​	nothing

 

[springran]

Thanks

 

[sandy666]

You're welcome