 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008can excel alert you when a number is less than a particular value
I am making a spreadshett to control stock and I want a message to come up and alert the user when the remaining stock of an item is less than 15, anyone know how to do this? If stock is in A1: =IF(A1<15,"Warning","") Hope this helps. Pete On May 7, 11:52 am, Megglesface <Megglesf...@discussions.microsoft.com> wrote: > I am making a spreadshett to control stock and I want a message to come up > and alert the user when the remaining stock of an item is less than 15, > anyone know how to do this? brilliant, thanks very much. sorry to be a pain but maybe you could help with my other question? If I want to use a cell value in a formula, but the cell is from another worksheet in the same book, how do I do this? I thought I just entered = into the formula box then clicked onto the other worksheet and selected the cell, but that doesnt seem to be working, little bit confused. ;-S Thanks > If stock is in A1: > [quoted text clipped - 9 lines] > > and alert the user when the remaining stock of an item is less than 15, > > anyone know how to do this? If you want to enter the formula directly, you would have something like: =Sheet2!A1 but the method you describe should give you this. If you have spaces in the sheet name then you have to enclose it with apostrophes like so: ='Sheet 2'!A1 Hope this helps. Pete On May 7, 1:40 pm, Megglesface <Megglesf...@discussions.microsoft.com> wrote: > brilliant, thanks very much. > [quoted text clipped - 23 lines] > > - Show quoted text - brilliant thats worked perfectly, just needed the apostrophes I think. thanks very much, been struggling with that one all day! > If you want to enter the formula directly, you would have something > like: [quoted text clipped - 40 lines] > > > > - Show quoted text - You're welcome - thanks for feeding back. Pete On May 7, 2:13 pm, Megglesface <Megglesf...@discussions.microsoft.com> wrote: > brilliant thats worked perfectly, just needed the apostrophes I think. > thanks very much, been struggling with that one all day! no worries. Im making a range of spreadsheets to control stock orders, simple i guess but I havnt done it before and no one else at the office has either, so its a case of teaching myself. must say, this forum is much better for answers than using the automatic help guide. > You're welcome - thanks for feeding back. > [quoted text clipped - 4 lines] > > brilliant thats worked perfectly, just needed the apostrophes I think. > > thanks very much, been struggling with that one all day! Hi, Another way is to use Conditional Formatting. This is a very effective tool for this sort of requirement. It's very simple to use, but see the Help on how to get started. Regards - Dave. > I am making a spreadshett to control stock and I want a message to come up > and alert the user when the remaining stock of an item is less than 15, > anyone know how to do this? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.