Thread: Formula if a number is between 2 amount than answer will be x
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Princess
 
Posts: n/a
Default Formula if a number is between 2 amount than answer will be x
I need help please!!! For example if I am in cell C3. I want to put a formula
in that if in B3 the number I have entered is between 4 and 6 for example
than i want the answer in C3 to be 2.
Reply With QuoteReply With Quote