If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
YES or NO formulas
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!!!! |
#2
|
|||
|
|||
YES or NO formulas
BG20: =IF(BF20=10000,"No","Yes")
and copy down -- HTH Bob "Alyssa" wrote in message ... 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!!!! |
#3
|
|||
|
|||
YES or NO formulas
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!!!! |
#4
|
|||
|
|||
YES or NO formulas
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!!!! |
Thread Tools | |
Display Modes | |
|
|