View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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