Posted to microsoft.public.excel.worksheet.functions

Gord Dibben Gord Dibben is offline

external usenet poster

Posts: 22,906

FORMULAES

Two cells to calculate are A1 and A2

In A3 enter =A1+A2

If the answer to A3 is negative it will show negative, if positive it will show
positive.

Gord Dibben MS Excel MVP

On Fri, 25 Jan 2008 16:20:00 -0800, Bennyboy
wrote:

I want to calculate two cells and have the answer showing a negative or
positive answer in another cell

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Formulaes	sandyramanuj	Excel Discussion (Misc queries)	4	May 3rd 07 04:19 PM
Files and formulaes	jam	Excel Worksheet Functions	0	December 11th 06 12:32 PM
Help with Macros or formulaes	Chris Wallace	Excel Discussion (Misc queries)	1	October 16th 06 05:51 PM
Help with Macros or formulaes	Chris Wallace	Excel Discussion (Misc queries)	0	October 16th 06 05:14 PM
copy formulaes w/o filename	jmwismer	Excel Discussion (Misc queries)	3	December 20th 05 07:25 AM

All times are GMT +1. The time now is 04:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us