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!!!! |
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) |