easy problem for an expert !!!

[Guest]

I wonder if anyone can help a novice please.

What I really want to happen is if a loss is made it is shown in the cell
marked loss and not shown in the total column as -£50

EG expense £150 , income£50, = total -£100 ( one column for profit the next
column to it is loss)

If that makes any sense


=IF(M2<L2,"Loss","None") this part worked, but something wrong somewhere

Thanks
Bob

 

[Jerry W. Lewis]

If functions are the way to do it, but you apparently already know that,
so I am not sure what your question is.

Jerry

 

[Guest]

What I want to happen is if the "profit" column shows a negative amount (
e.g.-£52.00), that amount is sent to another cell that is headed "loss"

 

[Jerry W. Lewis]

A formula in one cell cannot alter other cells, therefore you would use
an IF formula in appropriate cell in the Loss column. If by "sent to",
you mean that you want it to not be in the profit column, then you would
need a separate IF function there, assuming that the value is calculated
and not entered. E.g. in Profit you would have
=IF(formula>0,formula,"")
and in Loss you would have
=IF(formula<0,formula,"")

If you are comfortable in VBA, you could write a macro tied to the
Worksheet_Change change event that would move data. Such event driven
code could handle data entry in the wrong column, as well as calculated
results.

Sorry to be so general, but you haven't given much specific information.

Jerry

 

[Guest]

Many thanks Jerry

A formula in one cell cannot alter other cells, therefore you would use an
IF formula in appropriate cell in the Loss column. If by "sent to", you
mean that you want it to not be in the profit column, then you would need a
separate IF function there, assuming that the value is calculated and not
entered. E.g. in Profit you would have
=IF(formula>0,formula,"")
and in Loss you would have
=IF(formula<0,formula,"")

If you are comfortable in VBA, you could write a macro tied to the
Worksheet_Change change event that would move data. Such event driven
code could handle data entry in the wrong column, as well as calculated
results.

Sorry to be so general, but you haven't given much specific information.

Jerry

 

[Jerry W. Lewis]

You are welcome.

Jerry