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

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

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

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

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