A ankit bidawatka New Member Apr 23, 2013 #1 hi all, i want to enter formula in a cell and wants the result of formula in other but with out using VBA.
hi all, i want to enter formula in a cell and wants the result of formula in other but with out using VBA.
N nazmul_muneer Member Apr 23, 2013 #2 Dear ankit bidawatka, What kind of answer you want? Please specify clearly. Regards Muneer
D DaveTurton New Member Apr 23, 2013 #3 If the formula is entered in A1 and you want the result to be displayed in C1 type Code: =A1 in C1
M MikeLanglois New Member Apr 23, 2013 #5 That pretty much is a simple example. Make cell A1 invisible (white font, etc), and type =A1 into the cell that you want the formula result to be.
That pretty much is a simple example. Make cell A1 invisible (white font, etc), and type =A1 into the cell that you want the formula result to be.
N nazmul_muneer Member Apr 23, 2013 #6 Dear ankit bidawatka, Without any visible formula you can represent output in any cell using conditional formatting. I am giving you just an idea. You can customize as you want. Select a cell (D4) >Conditional formatting >New reules >Format all cells based on their values >Select icon sets >Customize icon set and complete conditional formatting Regards Muneer
Dear ankit bidawatka, Without any visible formula you can represent output in any cell using conditional formatting. I am giving you just an idea. You can customize as you want. Select a cell (D4) >Conditional formatting >New reules >Format all cells based on their values >Select icon sets >Customize icon set and complete conditional formatting Regards Muneer
