If formula

[boxboy30]

So I've written an if formula that works very well EXCEPT the false statement I would like it to input the information into another cell...

Take a look

=IF(B3=B1,G3+I1, input(I1 into J1))

no matter how I write it I can't get the false statment to work. How, if possible, can one do that?

 

[VoG]

Is it

=IF(B3=B1,G3+I1,I1)

 

[Joe4]

You just need to place the formula in the cell you want the result to appear in (i.e. I1). An Excel formula cannot update the value in another cell, only return information in the cell the formula is physically located in.

 

[boxboy30]

got it...and if I did want it to input the value into another cell I would have to create a macro that would copy into that cell, huh.

Okay thanks everyone

 

[Joe4]

and if I did want it to input the value into another cell I would have to create a macro that would copy into that cell, huh.

Usually that is not necessary.
Just place the formula in the cell you want to return the value to!
Meaning, if you want the value to return to cell I1, place your formula in cell I1.

If you have conditions where based on certain criteria you want a value returned in cell J1 or cell I1, but not both, then just post slight variations of the formula in each cell, so the formula in cell I1 will only return a value if the "I1 criteria" is met, and likewise, cell J1 will only return a value if the "J1" criteria is met (using an IF statement, you can return a blank if the condition is not met).