Excel function I cant figure out

Closed
Matt - Dec 28, 2014 at 12:36 PM
Hello, is this possible below? so A2 & A4 are the numbers I want ti time by 50% and only if B2 & B4 are equal or greater then 54%, so row "A" should equal Zero, and rows 4 should equal 100.00, can anyone help me out?


A B C D

MIN
2 100 48% 54% *Want this to equal A2*50% if 54% or greater. *should be Zero

4 200 56% 54% *Want this to equal A4*50% if 54 % or greater. *Should be 100