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