You cannot write to another cell using a formula.

You have to have the formula in B23

=IF(ISERROR(C23,0,"whatever")

The only way to write to a cell without a formula is through VBA

Do you want to go that route via sheet event code?

Private Sub Worksheet_Calculate()
On Error GoTo stoppit
Application.EnableEvents = False
With Me.Range("C23")
If IsError(.Value) Then
Me.Range("B23").Value = 0
Else: Me.Range("B23").Value = "whatever"
End If
End With
stoppit:
Application.EnableEvents = True
End Sub


Gord Dibben MS Excel MVP

On Mon, 18 May 2009 15:40:01 -0700, dorf
wrote:

I would like to test a condition in a cell and then write something in
another cell.

For Example my If statement is in cell d23 and this is what I want to do: If
c23=#VALUE! then b23=0.

Is this possible.