View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tom tom is offline
external usenet poster
 
Posts: 570
Default if statement with three different criterias?

I have a cell (B3) that has a number "7" and in cell (D3) I am trying to
write a formula to return the following:

If the cell is <6 I would like the formula return "Carton".
If the cell (B3) is between 7 and 12 I would like the formlua return "1/2
Pallet".
If the cell (B3) is 25 or greater, I want the formula to return "Full Pallet."

Thanks for the HELP,