| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I place a formula inside another formula?
What I'm looking to do is basically this:
=IF(C23<0,"=D20-C23","None") I want the formula to give me a number if true and say None if false |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I place a formula inside another formula?
Try this:
=IF(C23<0,D20-C23,"None") Does that help? *********** Regards, Ron XL2002, WinXP "Spanishearl" wrote: What I'm looking to do is basically this: =IF(C23<0,"=D20-C23","None") I want the formula to give me a number if true and say None if false |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I place a formula inside another formula?
Spanishearl wrote:
What I'm looking to do is basically this: =IF(C23<0,"=D20-C23","None") I want the formula to give me a number if true and say None if false try this way: =IF(C23<0,D20-C23,"None") -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I place a formula inside another formula?
You were very close.
Try this............=IF(C23<0,D20-C23,"None") Gord Dibben MS Excel MVP On Thu, 17 Aug 2006 18:42:01 -0700, Spanishearl wrote: What I'm looking to do is basically this: =IF(C23<0,"=D20-C23","None") I want the formula to give me a number if true and say None if false |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I place a formula inside another formula?
Thanks guys,
You helped me out big time! "Spanishearl" wrote: What I'm looking to do is basically this: =IF(C23<0,"=D20-C23","None") I want the formula to give me a number if true and say None if false |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I place the sheet tab name in my spreadsheet by formula? | Excel Worksheet Functions | |||
| Nesting-Don't use Blanks inside formula | Excel Worksheet Functions | |||
| Can I use a formula in place of OffsetRows? | Excel Discussion (Misc queries) | |||
| What takes the place of a space in a formula? | Excel Discussion (Misc queries) | |||
| Is there a formula that will place the sheet name in a cell? | Excel Worksheet Functions | |||
Linear Mode
