| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Analyzing multiple IF formulas for a single answer
Try this:
=IF(I8<=0,"NG",if(i8<1,"Undefined",if(i8<30,i8,30) )) Change "Undefined" to whatever you want to happen when I8 is between 0 and 1. Regards, Fred. "heyredone" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Analyzing multiple IF formulas for a single answer
Oh, thank you so very much! That worked perfectly!
-- heyredone "Fred Smith" wrote: Try this: =IF(I8<=0,"NG",if(i8<1,"Undefined",if(i8<30,i8,30) )) Change "Undefined" to whatever you want to happen when I8 is between 0 and 1. Regards, Fred. "heyredone" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Analyzing multiple IF formulas for a single answer
Glad I could help.
Regards, Fred. "heyredone" wrote in message ... Oh, thank you so very much! That worked perfectly! -- heyredone "Fred Smith" wrote: Try this: =IF(I8<=0,"NG",if(i8<1,"Undefined",if(i8<30,i8,30) )) Change "Undefined" to whatever you want to happen when I8 is between 0 and 1. Regards, Fred. "heyredone" wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
