ANSWERS: 2
  • 7 : 23 29 31 37 41 43 47
  • If you'd like, I can send you (or anyone who requests via my profile email) an Excel spreadsheet with a couple of User-Defined Functions that I've created in order to evaluate: 1. ListPrimes( Input1, Input2) -- list the prime numbers between two given values or cell references (Input1 and Input2), including the count of primes and 2. IsPrime ( Input1) -- evaluate whether a given value is a prime number or not. I'd include the commented code here, but both times I've tried so far AB has failed to record the response (which is kind of weird, because I've posted the text of Excel macros here before with no problem). Fred's answer is correct.

Copyright 2023, Wired Ivy, LLC

Answerbag | Terms of Service | Privacy Policy