View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lori Brockman
 
Posts: n/a
Default HOW DO I USE TWO IF FUNCTIONS IN ONE CELL?

I am trying to take one cell and say if my number is greater than 1 then use
that cell's number if not use the number 2 and if that number is greater than
13 then use the number 13. If the number is less than 13 then use that
cell's number. Can this be done in one cell using one formula?