| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula will not work
I typed the following formula in and is displays the formula in the cell just
as it was typed in instead of calculating the formula. =COUNTIF(C8:Q8,"=''") Those are two single quotes after the equal sign. What do I need to change or check? Les |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula will not work
most likely
The cell was formatted as text before you typed your formula in Solution copy the formula reformat as general and paste the formula back less likely press Ctrl + ` which is just to the left of the 1 key Mike "WLMPilot" wrote: I typed the following formula in and is displays the formula in the cell just as it was typed in instead of calculating the formula. =COUNTIF(C8:Q8,"=''") Those are two single quotes after the equal sign. What do I need to change or check? Les |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula will not work
The cell is most likely formatted as Text. Change the format to General or a
number style. When that is done you still need to update the cell. Double click the cell or use 2 on the cell and then exit edit mode. -- HTH... Jim Thomlinson "WLMPilot" wrote: I typed the following formula in and is displays the formula in the cell just as it was typed in instead of calculating the formula. =COUNTIF(C8:Q8,"=''") Those are two single quotes after the equal sign. What do I need to change or check? Les |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Max value formula doesn't work | Excel Discussion (Misc queries) | |||
| Formula will not work | Excel Discussion (Misc queries) | |||
| why doesn't this formula work? | Excel Worksheet Functions | |||
| The same formula doesn't work again? | Excel Worksheet Functions | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
Linear Mode
