ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   formulaes (https://www.excelbanter.com/excel-discussion-misc-queries/233519-formulaes.html)

Sharjeel

formulaes
 
I want to enter a large formula.
I know how to enter one. But I want other people to see what I have entered.
For example it should look like this (D=(A+B)/C). One option is to clip a
picture or from a pdf file and paste it in excel. Is there any other way.


D = A+B
C

Jacob Skaria

formulaes
 
The formula bar displays that when you select the cell.
OR
You can make use of the comments column with an explanasion..
--
If this post helps click Yes
---------------
Jacob Skaria


"SHARJEEL" wrote:

I want to enter a large formula.
I know how to enter one. But I want other people to see what I have entered.
For example it should look like this (D=(A+B)/C). One option is to clip a
picture or from a pdf file and paste it in excel. Is there any other way.


D = A+B
C


Roger Govier[_3_]

formulaes
 
Hi

In a column alongside your formula, repeat the formula but place a single
quote in front of it
'(D=(A+B)/C)

Incidentally, the outer set of parentheses are not necessary.
--
Regards
Roger Govier

"SHARJEEL" wrote in message
...
I want to enter a large formula.
I know how to enter one. But I want other people to see what I have
entered.
For example it should look like this (D=(A+B)/C). One option is to clip a
picture or from a pdf file and paste it in excel. Is there any other way.


D = A+B
C




All times are GMT +1. The time now is 02:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com