ADDING/SUBTRACTING FROM RIGHT TO LEFT

[Guest]

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

 

[shail]

Hi Joanne,

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

Thanks

Shail

 

[Guest]

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]

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

 

[Guest]

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

 

[shail]

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

 

[Guest]

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