View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
NBVC[_130_] NBVC[_130_] is offline
external usenet poster
 
Posts: 1
Default Expanding Range in Formula?


=IF(Sumproduct(--(O5:O20(O22-4*D3))),"Bad Data",0)

This will return "Bad Data" if any value in O5:O20 is greater
thanO22-4*D3


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=122849