Thread: Formula to write a value into a different cell.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_4_] Jim Thomlinson[_4_] is offline
external usenet poster
  
Posts: 1,119
Default Formula to write a value into a different cell.
=if(B210, C2, D2)

This formula (placed in A2 or ???) will look at the value in Cell B2. If B2
is greater than 10 then it returns the value of C2 else it returns the value
of D2...
--
HTH...

Jim Thomlinson


"Mr. Clean" wrote:

I need a formula in one cell that, under certain conditions (and IF
statement), writes the value of one cell into another cell. In this case, I
can't use a macro. Anyone done this sort of thing before?
Reply With QuoteReply With Quote