Thread: excel formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
las
 
Posts: n/a
Default excel formula

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