Thread: Logic Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Truc Lopez Truc Lopez is offline
external usenet poster
 
Posts: 6
Default Logic Formula

I want to create a formula to look at a value in a cell to see if it is
greater or less than a specified number. If the cell is less than the
specified number then I want to use that number. If the cell is greater than
the specified number then I want to use the specified number.

Example:

20 ---- If cell is < 80, then 20; if cell is or= 80, then 80

Thank you in advance for your help.