View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
excel excel is offline
external usenet poster
 
Posts: 16
Default greater than larger than

say cell a1 has a figure, say 10, and i want that figure to put into
cell b1, a 1, if the figure in a1 is less that 8 but greater than 0,
how would i express that in a formula?