How can I place a formula inside another formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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:
=IF(C23<>0,D20-C23,"None")

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

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

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

XL2002, WinXP
 
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
 
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
 
You were very close.

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


Gord Dibben MS Excel MVP
 
You were very close.

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


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If condition for Blank Cell 4
Divide by zero error 3
Looking up in a table 3
how do I control autofill to do my progression? 2
Change of cell format if overwritten by User 1
Vlookup bug? 6
Clever formula required (to find the word directly preceding mychosen word) 3
How to add a formula using a macro 1

Back
Top