Testing an if statement and placing result in different cell

[RuudsRightFoot]

Does anyone know if there is a way of checking if something is true and
if so placing a number in another cell - Something like:
=if(x>=y,c3=a1+a2,0)
???
Don't know if I would use the if statement here or not - any help much
appreciated...

 

[J.E. McGimpsey]

No - worksheet functions can't change values in other cells.
However, in C3, you could put:

=IF(x>=y, A1+A2, 0)

 

[Andy Wiggins]

You can't do this as the direct result of a formula, but you could capture
the event and use VBA to populate the target cell.

Question: Why not put the formula into cell C3 as:
=if(x>=y,a1+a2,0)

--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "The Excel Auditor" and "Byg Tools for VBA"

 

[RuudsRightFoot]

Reason I can't put the formula in the C3 cell is coz the cell is then
read as not empty by the graphs that I'm creating and as a result it
reads that my company's revenue for next month is 0 - doesn't go down
well with the bosses!!! This is the real issue, and posted this up
previously so am thinking of ways around this problem. Maybe will need
VB - have no knowledge of that at all... I'll include the graph and
data that goes into making these graphs if you could have a look at
them and see what I'm going on about that would be great...

 

[Ken Wright]

Would the following in C3 do it?

IF(x>=y, A1+A2, NA())

#N/A will not get plotted on a bar or column graph (Still looks funny on a line graph though).

Failing that, you can use a dynamic range to plot your graphs.

http://cpearson.com/excel/excelF.htm#DynamicRanges

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q183446

 

[RuudsRightFoot]

You hit the nail on the head there. It's a line graph and so there is
this big dip in the middle of the graph! Can anyone let me know the VB
that would transfer data to this cell if true then???