View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John Sofillas John Sofillas is offline
external usenet poster
 
Posts: 13
Default Expanding Range in Formula?

The formula below works the way I want it to for cell O5. How can I
open this formula up for a range of cells O5:O20?

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

As always, much appreciated for the advice.