View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dorf dorf is offline
external usenet poster
 
Posts: 1
Default How do I test a condition in one cell and write to another.

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.