You cannot combine the two, since they give totally unrelated results. The
first givres either an "0" or the value of F16, the other either B10*0.05 or
D10. As such, they should be in seperate cells?

"las" wrote:

if I have a formula that reads:

=IF(D22="no",0,IF(D22="yes",F16))

How combine it whith this formula so that both will happen at the same time:

=IF(B10*0.05<D10,B10*0.05,D10)

thanks for any help :)
las