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