| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMULA DOES NOT WORK
I have the following formula typed into my cell:
=If(a1="","",a2) I mean: If the contents of a1 is blank, insert a blank; otherwise, insert the contents of cell a2. IT DOES NOT WORK!!!! Maybe, the format of a1 is in error; but, anyway, a blank a1 does NOT yield a blank in my cell, and vice-versa. WHAT AM I DOING WRONG?? How is this fixed? Thank you, FLKulchar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to work in a 3-d reference with 2 work books | Excel Worksheet Functions | |||
| Sorting the cells of a formula causes the formula to not work | Excel Worksheet Functions | |||
| Help, I need a formula for work. | Excel Worksheet Functions | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
| extract a foldername with a formula-update formula does not work | Excel Programming | |||
Threaded Mode
