View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jenn jenn is offline
external usenet poster
 
Posts: 107
Default Checking one cell, if number is a range then this

I need help entering a formula and have no idea how to do it. Thanks in
advance. I want to calculate how many batches of batter I need for baking
certain sized cakes.

I have one column that calculates the total cups of batter I need per pan
size. If that number is less than or equal to 7 I need it to display "1", if
it's 7.01 to 14 I need it to display "2", if it's 14.01 to 21 I need it
display "3'.

Please help! Thanks