View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MK MK is offline
external usenet poster
 
Posts: 57
Default excel formula for a reference between two numbers

I am trying to set up a formula for a cell (b2) that references another cell
(A1).
If cell A1 is 200 but <300, then list A1; if not, then leave blank. Can
anyone help me? Thanks!