View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
spreadbet
 
Posts: n/a
Default Help With Formula Please


Hello I hope someone can help me I spreadbet and have a program that
triggers bets using excel I need a formula that will buy two shares but
only when they are priced below 2.

I have this so far but all it achieves is the buying of one bet when
two are under 2

IF(AND(AND(r_1_layp<2.0, r_2_layp<2.0), OR(lay_price<=r_1_layp,
lay_price<=r_2_layp)), 2, 0)

I hope someone can help me someone else helped me with the above but we
dont know how to get it to work!

thanks in advance


--
spreadbet
------------------------------------------------------------------------
spreadbet's Profile: http://www.excelforum.com/member.php...o&userid=35634
View this thread: http://www.excelforum.com/showthread...hreadid=554220