HOW DO I USE TWO IF FUNCTIONS IN ONE CELL?

[Guest]

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?

 

[Guest]

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


Is that what you're looking for?

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