 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / December 2005HOW 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? 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 > 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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.