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

Try this:
For
A1: (the first number)
A2: (the second number)
A3: =IF(A11,A1,MIN(B1,13))


Is that what you're looking for?

***********
Regards,
Ron


"Lori Brockman" wrote:

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?