ADDING/SUBTRACTING FROM RIGHT TO LEFT
 

I am trying to add and/or subtract columns reading from right to left. I
cannot figure it out - please help.

ADDING/SUBTRACTING FROM RIGHT TO LEFT
 

Hi Joanne,

Can you further clarify me what exactly you need to do?

Thanks

Shail


joanne wrote:
I am trying to add and/or subtract columns reading from right to left. I
cannot figure it out - please help.

ADDING/SUBTRACTING FROM RIGHT TO LEFT
 

I am tracking my commissions. For instance, my columns are reading
Jan./Feb./March etc. the column before Jan. I would like to add the totals -
sometimes there are commissions taken away therefore, the column before the
first month needs to reflects plus but also negative numbers.

"shail" wrote:

Hi Joanne,

Can you further clarify me what exactly you need to do?

Thanks

Shail


joanne wrote:
I am trying to add and/or subtract columns reading from right to left. I
cannot figure it out - please help.

ADDING/SUBTRACTING FROM RIGHT TO LEFT
 

Hi again Joanne,

In that case you might need something which tells the function to add
the totals or in the other case substracts it. Am I correct in thinking
this way.

If so then
Have one more column somewhere in your worksheet which have a YES or NO
option. If Yes is selected then it adds and when NO is selected it will
substract.

=if(E1="YES",A1+B1,if(E1="NO",A1-B1,""))

This might solve your query

Thanks

Shail

joanne wrote:
I am tracking my commissions. For instance, my columns are reading
Jan./Feb./March etc. the column before Jan. I would like to add the totals -
sometimes there are commissions taken away therefore, the column before the
first month needs to reflects plus but also negative numbers.

"shail" wrote:

Hi Joanne,

Can you further clarify me what exactly you need to do?

Thanks

Shail


joanne wrote:
I am trying to add and/or subtract columns reading from right to left. I
cannot figure it out - please help.

ADDING/SUBTRACTING FROM RIGHT TO LEFT
 

Thank you Shail however I'm more confused now then before. I am new at excel
and not very computer literate.

"shail" wrote:

Hi again Joanne,

In that case you might need something which tells the function to add
the totals or in the other case substracts it. Am I correct in thinking
this way.

If so then
Have one more column somewhere in your worksheet which have a YES or NO
option. If Yes is selected then it adds and when NO is selected it will
substract.

=if(E1="YES",A1+B1,if(E1="NO",A1-B1,""))

This might solve your query

Thanks

Shail

joanne wrote:
I am tracking my commissions. For instance, my columns are reading
Jan./Feb./March etc. the column before Jan. I would like to add the totals -
sometimes there are commissions taken away therefore, the column before the
first month needs to reflects plus but also negative numbers.

"shail" wrote:

Hi Joanne,

Can you further clarify me what exactly you need to do?

Thanks

Shail


joanne wrote:
I am trying to add and/or subtract columns reading from right to left. I
cannot figure it out - please help.

ADDING/SUBTRACTING FROM RIGHT TO LEFT
 

Sorry Joanne for making you confused.

Write down the function where you are adding or substracting the
numbers as :

=if(E1="YES",A1+B1,if(E1="NO",A1-B1,""))

A1 and B1 are just examples to tell you how you write a function


And at the column you added just now for telling to Add or Substracted
do as below:

1. Select Data / Validation
2. Choose Allow - Select List
3. Write Yes, No ie., Yes (comma) No

Am I making it clear to you.

You can send me an email with the XLS


Thanks

Shail


joanne wrote:
Thank you Shail however I'm more confused now then before. I am new at excel
and not very computer literate.

ADDING/SUBTRACTING FROM RIGHT TO LEFT
 

Thanks Shail - something just came up - gotta run - hopefully I can do this
later. Thank you so much.

"shail" wrote:

Sorry Joanne for making you confused.

Write down the function where you are adding or substracting the
numbers as :

=if(E1="YES",A1+B1,if(E1="NO",A1-B1,""))

A1 and B1 are just examples to tell you how you write a function


And at the column you added just now for telling to Add or Substracted
do as below:

1. Select Data / Validation
2. Choose Allow - Select List
3. Write Yes, No ie., Yes (comma) No

Am I making it clear to you.

You can send me an email with the XLS


Thanks

Shail


joanne wrote:
Thank you Shail however I'm more confused now then before. I am new at excel
and not very computer literate.