OfficeFrustration - View Single Post

**FSt1** · April 30th, 2010, 10:16 PM posted to microsoft.public.excel.worksheet.functions

oops.
that should be
=IF(BF20=10000,"No","Yes")

sorry.
FSt1

"FSt1" wrote:

hi
=IF(BG20=10000,"No","Yes")

regars
FSt1

"Alyssa" wrote:

Hi,

I have a column that has a series of numbers it will always be either 10000
or 10100 , I want it to return a No for 10000 or Yes for 10100 in the field
next to it,

I have tried and I can't seem to make it work, I can do one or the other,
any assistance would be greatly appreciated.

The cells I am using for example are BF20 to BF34 and the answer I want to
go into BG20 to BG34

Thanks!!!!