| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine functions into one cell | Excel Worksheet Functions | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| How can I copy cell formats in functions? | Excel Worksheet Functions | |||
| Copying and Filling Cell With Functions | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Linear Mode
