post positive sum as a negative? help!

[Brainless_in_Boston]

Good ole microsoft... I have entered 2 positiive numbers in sequential cells
in a column, however, I want to display their (positive) sum as a negative,
so I can tie out a premium cost against another number which is positive.
Complicated, I know, but not easy to do.

I tried the logical math stuff, multiply by negaive 1, put a neg sign in
front of the cell with no luck.

I searched for "help" (for those who have not seen my posts, I hate MS's
search algorithm with a zeal usually reserved for somebody that has just
stolen from me), and of course my search yielded a stunning array of totally
unrelated help topics...

OOOHHH!! Stop the presses, I can enter =-SUM(C356:C346) and get it... trial
and error wins over the search algorithm.

thanks for reading...

Mark
aka Brainless

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...heet.functions

[Marijus]

SGkgDQppZiBpIHVuZGVzdGFuZCB5b3UgcmlnaHQNCnNvIHlvdSB3YW50IHRvIGRvIGxpa2UgdGhp
cw0KaW5wdXQgaW4gQTEgICAgICA1IHBvc2l0aXZlIG51bWJlcg0KaW5wdXQgaW4gQTIgICAgICA2
IHBvc2l0aXZlIG51bWJlcg0KYW5kIGluIGNlbGwgQTMgZ2V0IC0xMQ0KaWYgaWBtIHJpZ2h0IHNv
IHlvdSBzaG91bGQgd3JpdGUgaW4gQTMgdGhpcyBmb3JtdWxhOg0KPWNvbmNhdGVuYXRlKCItIjtz
dW0oQTE6QTIpKQ0KYW5kIHRoZSByZXN1bHQgeW91YGxsIGdldCAtMTENCg0KDQotLSANCk0uQS4N
CiJCcmFpbmxlc3NfaW5fQm9zdG9uIiA8QnJhaW5sZXNzaW5Cb3N0b25AZGlzY3Vzc2lvbnMubWlj
cm9zb2Z0LmNvbT4gd3JvdGUgaW4gbWVzc2FnZSBuZXdzOjlENjg5QjRELUFBRDYtNDlGRS05QjY0
LUEwRjc5RjI3NTVGOEBtaWNyb3NvZnQuY29tLi4uDQo+IEdvb2Qgb2xlIG1pY3Jvc29mdC4uLiBJ
IGhhdmUgZW50ZXJlZCAyIHBvc2l0aWl2ZSBudW1iZXJzIGluIHNlcXVlbnRpYWwgY2VsbHMgDQo+
IGluIGEgY29sdW1uLCBob3dldmVyLCBJIHdhbnQgdG8gZGlzcGxheSB0aGVpciAocG9zaXRpdmUp
IHN1bSBhcyBhIG5lZ2F0aXZlLCANCj4gc28gSSBjYW4gdGllIG91dCBhIHByZW1pdW0gY29zdCBh
Z2FpbnN0IGFub3RoZXIgbnVtYmVyIHdoaWNoIGlzIHBvc2l0aXZlLiANCj4gQ29tcGxpY2F0ZWQs
IEkga25vdywgYnV0IG5vdCBlYXN5IHRvIGRvLiANCj4gDQo+IEkgdHJpZWQgdGhlIGxvZ2ljYWwg
bWF0aCBzdHVmZiwgbXVsdGlwbHkgYnkgbmVnYWl2ZSAxLCBwdXQgYSBuZWcgc2lnbiBpbiANCj4g
ZnJvbnQgb2YgdGhlIGNlbGwgd2l0aCBubyBsdWNrLg0KPiANCj4gSSBzZWFyY2hlZCBmb3IgImhl
bHAiIChmb3IgdGhvc2Ugd2hvIGhhdmUgbm90IHNlZW4gbXkgcG9zdHMsIEkgaGF0ZSBNUydzIA0K
PiBzZWFyY2ggYWxnb3JpdGhtIHdpdGggYSB6ZWFsIHVzdWFsbHkgcmVzZXJ2ZWQgZm9yIHNvbWVi
b2R5IHRoYXQgaGFzIGp1c3QgDQo+IHN0b2xlbiBmcm9tIG1lKSwgYW5kIG9mIGNvdXJzZSBteSBz
ZWFyY2ggeWllbGRlZCBhIHN0dW5uaW5nIGFycmF5IG9mIHRvdGFsbHkgDQo+IHVucmVsYXRlZCBo
ZWxwIHRvcGljcy4uLg0KPiANCj4gT09PSEhIISEgU3RvcCB0aGUgcHJlc3NlcywgSSBjYW4gZW50
ZXIgPS1TVU0oQzM1NjpDMzQ2KSBhbmQgZ2V0IGl0Li4uIHRyaWFsIA0KPiBhbmQgZXJyb3Igd2lu
cyBvdmVyIHRoZSBzZWFyY2ggYWxnb3JpdGhtLg0KPiANCj4gdGhhbmtzIGZvciByZWFkaW5nLi4u
DQo+IA0KPiBNYXJrDQo+IGFrYSBCcmFpbmxlc3MNCj4gDQo+IC0tLS0tLS0tLS0tLS0tLS0NCj4g
VGhpcyBwb3N0IGlzIGEgc3VnZ2VzdGlvbiBmb3IgTWljcm9zb2Z0LCBhbmQgTWljcm9zb2Z0IHJl
c3BvbmRzIHRvIHRoZSANCj4gc3VnZ2VzdGlvbnMgd2l0aCB0aGUgbW9zdCB2b3Rlcy4gVG8gdm90
ZSBmb3IgdGhpcyBzdWdnZXN0aW9uLCBjbGljayB0aGUgIkkgDQo+IEFncmVlIiBidXR0b24gaW4g
dGhlIG1lc3NhZ2UgcGFuZS4gSWYgeW91IGRvIG5vdCBzZWUgdGhlIGJ1dHRvbiwgZm9sbG93IHRo
aXMgDQo+IGxpbmsgdG8gb3BlbiB0aGUgc3VnZ2VzdGlvbiBpbiB0aGUgTWljcm9zb2Z0IFdlYi1i
YXNlZCBOZXdzcmVhZGVyIGFuZCB0aGVuIA0KPiBjbGljayAiSSBBZ3JlZSIgaW4gdGhlIG1lc3Nh
Z2UgcGFuZS4NCj4gDQo+IGh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9vZmZpY2UvY29tbXVuaXR5
L2VuLXVzL2RlZmF1bHQubXNweD9taWQ9OWQ2ODliNGQtYWFkNi00OWZlLTliNjQtYTBmNzlmMjc1
NWY4JmRnPW1pY3Jvc29mdC5wdWJsaWMuZXhjZWwud29ya3NoZWV0LmZ1bmN0aW9ucw==