=IF(B6<=15.4,B6/56,(100-B5)/84.5*B5/56)

--
HTH

Bob Phillips

wrote in message
ups.com...
I have tried this formula several ways and nothing works, please help
=IF(B6<=15.4,"/56)","IF(B6=15.5("100"-B5)/84.5*B5/56") So basically if
cell B6 is less than or equal to 15.4 only divide by 56. If cell B6 is
greater than or equal to 15.5 run the following formula
(100-B5)/84.5*B5/56")