Placing Result In Different Cell

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I am trying to place the results of a formula in cell to another cell.
For example:
In B1: If (A1=6, C1=1, "")
It seems like it should work, but it will give me false in B1. How
can I achieve this result?
Thanks for your help!
Jeff
 
Jeff

Formulas can't return values to other cells. Only to the cell in which they
are entered.

If you want something in C1 you must write a formula there or resort to VBA,
perhaps Event code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy and paste the cell with formula ="1" 3
Subtraction of 2 numbers/cells 3
Decimal Place goes crazy when using the "&" Sign. 4
How To Have A Cell Be Blank If... 2
DISPLAY A RESULT 3
How to change the year digit? 4
Running Balance in a row 1
How to copy the function SUM but offseted in 7 columns 2

Back
Top