ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   manual numbers entered in formula (https://www.excelbanter.com/excel-discussion-misc-queries/150877-manual-numbers-entered-formula.html)

aprilm

manual numbers entered in formula
 
Is there a function within Excel, that allows you to search for any relevant
cells that have a hardcoded amount within a formula, ie. adding, subtracting,
dividing or multiplying a harcoded number.
eg. cell B2 + cell B3 + 5 and then identifying that cell because it has a +5
(however, being able to identify any hardcoded number anywhere from
-9,999,999,999 to 9,999,999,999)


All times are GMT +1. The time now is 09:51 AM.

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