Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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)
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In spread sheet the numbers entered as whole numbers become decim George A. Yorks Excel Worksheet Functions 3 January 28th 07 07:41 PM
All Numbers entered divided by 100,000,000,000! peacepuppy Excel Discussion (Misc queries) 3 March 3rd 06 11:28 PM
Manual entered data on excel ms query is misaligned after refresh Paul Mansfield Excel Discussion (Misc queries) 0 August 18th 05 04:28 PM
numbers being entered show in formula bar but not in cell? Jim in Florida Excel Discussion (Misc queries) 2 May 13th 05 06:36 PM
Numbers entered change to 0 ketrash Excel Discussion (Misc queries) 1 February 4th 05 10:53 PM


All times are GMT +1. The time now is 03:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"