How can I place a formula inside another formula?

S

Spanishearl

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
 
R

Ron Coderre

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

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

XL2002, WinXP
 
F

Franz Verga

Spanishearl said:
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
Click to expand...


try this way:

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

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
G

Gord Dibben

You were very close.

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


Gord Dibben MS Excel MVP
 
Top