#### InvictusSol

##### New Member

- Joined
- Jan 5, 2016

- Messages
- 15

This will be fairly easy no doubt, but I've already wasted an hour+ trying to come up with a solution so any help is of course appreciated.

I have a column of numbers (let's say A2:A20) which are populated randomly by integers between 1 and 100. These numbers in actuality are the %age chance of an event occurring.

**I'd like to populate B2:B20 with either a YES or NO, based on the %age chance represented in A.**

For instance, "82" is in A3 and I'd like B3 to have an 82% chance or 82/100 chance of returning "YES" and an 18% chance of returning "NO".

Conversely, "10" is in A4 and I'd like B4 to have an 10% chance or 10/100 chance of returning "YES" and an 90% chance of returning "NO".

Again, any assistance greatly appreciated. Thanks.