I am adding numerators from fractions and currently using this formula:
=SUMPRODUCT(--(LEFT(0&I35:I38,FIND("/",0&I35:I38)-1)))
25/20
25/20
10/20
10/20
70
I want my formula to cap out at the denominator however, for example on my first two cell IF numerator is more than denominator, use denominator. Current formula gives 70, looking to get 60 (20+20+10+10)
Can anyone help?
Bookmarks