| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Analyzing multiple IF formulas for a single answer
I am creating a worksheet that will require analyzing multiple IF formulas to
provide a single answer in a cell. Currently in cell J8 I have: =IF(I8<=0,"NG",IF(I8=30,"30")) I want to also add ... if I8=1 and I8<30, then it inserts the number that is currently in cell I8. How do I add this formula to the current string I have? Thank you! -- heyredone |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple formats in a single cell with multiple formulas | Excel Worksheet Functions | |||
| Using a single cell refernce to change multiple formulas | Excel Worksheet Functions | |||
| Using a single cell in multiple formulas | Excel Worksheet Functions | |||
| How to create Multiple Conditional Formulas in a single cell? | Excel Discussion (Misc queries) | |||
| Displaying the results of multiple formulas in a single cell. | New Users to Excel | |||
Threaded Mode
