Multiple formula tasking

[tarvessp]

[TABLE="width: 572"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD]ITEM[/TD]
[TD]DATABASE 1[/TD]
[TD]DATABASE 2[/TD]
[TD]DELTA[/TD]
[/TR]
[TR]
[TD]TRUCK STAKE 6X6 46000 GV[/TD]
[TD]183[/TD]
[TD]184[/TD]
[TD]100.55%[/TD]
[/TR]
[TR]
[TD]TRK STAKE 46000 GVW[/TD]
[TD]161[/TD]
[TD]161[/TD]
[TD]100.00%[/TD]
[/TR]
[TR]
[TD]TRK SUV 8600[/TD]
[TD]160[/TD]
[TD]152[/TD]
[TD]95.00%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 4"]A formula for all cells under the delta. If both databases match, they should be at 100%. Trying to get the inventory delta to reflect a percentage, regardless of which database has more items. None of the results should be over 100%.

I started with a formula from your site. =IF(B2>B3,+B2-B3, B3-B2). [/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]

 

[Eric W]

Welcome to the forum.

Maybe:

=MIN(B2,C2)/MAX(B2,C2)

 

[tarvessp]

Eric,
Total AWESOMENESS! Worked perfectly thank you.
Steve