Formula Help

K

Karl

If I have a number in cell A1 like 5 and another number in cell A3 like 6 I want the number in A7 to show -1 and if cell A3 was 4 to read +1 and if the numbers are 2 away from A1 then the numbers in cell A7 would be -2 or +2 depending on the number in cell A3. All help is appreciated. Thanks Karl
 
R

RagDyer

You must be kidding!

=A1-A3
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

If I have a number in cell A1 like 5 and another number in cell A3 like 6 I
want the number in A7 to show -1 and if cell A3 was 4 to read +1 and if the
numbers are 2 away from A1 then the numbers in cell A7 would be -2 or +2
depending on the number in cell A3. All help is appreciated. Thanks Karl
 
K

Karl

I don't mean a straight subtraction I want the cell A7 to actually show -1 or +1 not 6-1 which would show 5. Maybe i'm not explaining it very well. I want the numbers in cell A7 to actually be -1 or +2 like this. thanks
 
R

RagDyer

Use the same, simple subtraction formula, but use this custom format for A7:

+ # ; - # ; 0 (spaces added for clarity)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I don't mean a straight subtraction I want the cell A7 to actually show -1
or +1 not 6-1 which would show 5. Maybe i'm not explaining it very well. I
want the numbers in cell A7 to actually be -1 or +2 like this. thanks
 
D

David McRitchie

Hi Karl,
I hope you got the answer you wanted but for next time perhaps if you laid out
what you want on a spreadsheet then post in text what you start with
and what you want it to look like when finished. We're much better at looking
at spreadsheets than trying to untwist contorted grammar. In fact if you
make it really simple to be answered, you might find it possible to answer
your own question, or at least point out the one part that you need.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Karl said:
I don't mean a straight subtraction I want the cell A7 to actually show -1 or +1 not 6-1 which would show 5. Maybe i'm not
Click to expand...
explaining it very well. I want the numbers in cell A7 to actually be -1 or +2 like this. thanks
 
Top