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

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

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