Thread: can excel alert you when a number is less than a particular value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default can excel alert you when a number is less than a particular value
If stock is in A1:

=IF(A1<15,"Warning","")

Hope this helps.

Pete

On May 7, 11:52*am, Megglesface
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?

Reply With QuoteReply With Quote