I did a tiny bit more fiddling, and this is the formula that works best for me.
=5+(0.55*B47*100)+(1.45*C47*100)
I input the numbers for 30-1 alloy using 3% tin and 97% lead.
The result returned is 6.65 BHN ... and I already know that the right value for 30-1 is 6.66 BHN.
So this formula is close enough for me.