ExcelBanter - HOW DO I USE TWO IF FUNCTIONS IN ONE CELL?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - HOW DO I USE TWO IF FUNCTIONS IN ONE CELL? (https://www.excelbanter.com/excel-worksheet-functions/60270-how-do-i-use-two-if-functions-one-cell.html)

Lori Brockman

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?

Ron Coderre

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?

All times are GMT +1. The time now is 04:29 AM.