Thread: greater than larger than
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default greater than larger than
=(A10)*(A1<8)


"excel" wrote:

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?


Reply With QuoteReply With Quote