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

Please elaborate
D22 Yes No
B10*0.05 <D10 case a case b
=D10 case c case d
Tell us what is to happen in each case
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"las" wrote in message
...
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