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 |