Thread: How do I test a condition in one cell and write to another.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar Elkar is offline
external usenet poster
  
Posts: 964
Default How do I test a condition in one cell and write to another.
No, not possible. A formula in one cell cannot place it's results in a
different cell.

Why not just place the formula in cell B23? Or, if B23 already contains a
formula, just incorporate this into it. Something like:

=IF(ISERROR(C23),0,YourFormula)

HTH
Elkar

"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.
Reply With QuoteReply With Quote