| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula text in woorksheet cell
I am entering a formula for a list of cells. When I write the formula and
enter it the formula shows up in the formula bar but another text style formula shows in the formula result cell on the woorksheet. The calculation is ok but I would prefer if this other formula was not showing in all the other cells on my list. Can anyone explain to me how to hide them without loosing the formula for the cell. The formula is =6000/D16 I have used =sum(6000/D16) it works as well. The answer shows as correct. When I do copy and paste in the column the #DIV/0! shows up in the whole list with a green corner in the top left of the list. -- #DIV/0! #DIV/0! 12.85 466.93 Max |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula text in woorksheet cell
Try the below version
=IF(D16,6000/D16,"") If this post helps click Yes --------------- Jacob Skaria "mexmex" wrote: I am entering a formula for a list of cells. When I write the formula and enter it the formula shows up in the formula bar but another text style formula shows in the formula result cell on the woorksheet. The calculation is ok but I would prefer if this other formula was not showing in all the other cells on my list. Can anyone explain to me how to hide them without loosing the formula for the cell. The formula is =6000/D16 I have used =sum(6000/D16) it works as well. The answer shows as correct. When I do copy and paste in the column the #DIV/0! shows up in the whole list with a green corner in the top left of the list. -- #DIV/0! #DIV/0! 12.85 466.93 Max |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula text in woorksheet cell
Jacob
Thanks for the assistance it worked fine Thanks muchly -- Max "Jacob Skaria" wrote: Try the below version =IF(D16,6000/D16,"") If this post helps click Yes --------------- Jacob Skaria "mexmex" wrote: I am entering a formula for a list of cells. When I write the formula and enter it the formula shows up in the formula bar but another text style formula shows in the formula result cell on the woorksheet. The calculation is ok but I would prefer if this other formula was not showing in all the other cells on my list. Can anyone explain to me how to hide them without loosing the formula for the cell. The formula is =6000/D16 I have used =sum(6000/D16) it works as well. The answer shows as correct. When I do copy and paste in the column the #DIV/0! shows up in the whole list with a green corner in the top left of the list. -- #DIV/0! #DIV/0! 12.85 466.93 Max |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The result of a formula referring to a cell with formula as text? | Excel Worksheet Functions | |||
| Copy and Paste information from woorksheet onto different workbook | Excel Discussion (Misc queries) | |||
| Woorksheet locked on active cell | Excel Worksheet Functions | |||
| How do I delete Rows from my woorksheet? | Excel Worksheet Functions | |||
| match cell text with text in formula | Excel Worksheet Functions | |||
Linear Mode
