How can I place a formula inside another formula?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Spanishearl - 18 Aug 2006 02:42 GMT

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 to this Message

Ron Coderre - 18 Aug 2006 02:50 GMT

Try this:
=IF(C23<>0,D20-C23,"None")

Does that help?
***********
Regards,
Ron

XL2002, WinXP

> 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 to this Message

Franz Verga - 18 Aug 2006 02:50 GMT

> 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")

Signature

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Reply to this Message

Gord Dibben - 18 Aug 2006 03:09 GMT

You were very close.

Try this............=IF(C23<>0,D20-C23,"None")

Gord Dibben MS Excel MVP

>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 to this Message

Spanishearl - 19 Aug 2006 20:49 GMT

Thanks guys,

You helped me out big time!

> 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 to this Message