| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
| E2007 formulas display as formulas, not results | Excel Worksheet Functions | |||
| Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
Hybrid Mode
