• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

basic question... I am trying to get the difference between two cells.

J

JDS

New Member
My problem is that I don't know how to do it so that the result is positive or negative when approproate. Any help greatly appreciated!
 
Hi ,

You need to decide when the result should be positive and when it should be negative.

For example , if you have data in 2 columns A and B , you may choose to decide that you will subtract the data in column B from the data in column A. In this case , the formula to be put in , say column C , starting from cell C2 , would be :

=A2 - B2

Copy this formula down.

When the data in column A is bigger than the data in column B , the result will be positive , otherwise the result will be negative.

Instead , if you change the above formula to :

=B2 - A2

and copy this down , the result will be vice-versa.

Narayan
 
The data in column A is a fixed number. The data in column B is a number entered monthly and sometimes it is bigger than it's respective cell in column A and sometimes it is smaller...Here is what I am trying to do. We have a starting weight when people come in. Then every month we weigh them. I am trying to getting the worksheet to automatically compare each month to the original weight. I need to know if it is more or less and by how much.
 
See the file, actually you did not mention your required format. I had put the formula in H2:J3. Or tell your req. format.

Regards,
 
I am trying to getting the worksheet to automatically compare each month to the original weight. I need to know if it is more or less and by how much.
Click to expand...

IN Cells H2:J6 it comparing and giving you an information on how much loss or gain.

Regards,
 
You must log in or register to reply here.
Back
Top