Posted to microsoft.public.excel.programming

Smilen2day Smilen2day is offline

external usenet poster

Posts: 9

formual help

I have a spread sheet that I am working on. When I enter an amount in column
A, I want a formula so that it will take the number I enter minus 616.67.
And if the sum is a negative amount I want the sum to enter in column b, but
if the sum is a positive amount I want the sum to enter in column c.

How do I do this?

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
some help with an IF formual or something like it	Lost Will	Excel Worksheet Functions	4	November 19th 08 12:00 PM
WHAT DOES FORMUAL =C8+ 15 DO	Tara	Excel Discussion (Misc queries)	1	January 4th 07 03:38 PM
Formual	Winnie	Excel Discussion (Misc queries)	1	November 13th 06 10:19 AM
Set Formual	Winnie	Excel Discussion (Misc queries)	2	November 13th 06 09:47 AM
what is mean by ^ in formual	khan	Excel Programming	2	October 13th 05 12:16 PM

All times are GMT +1. The time now is 09:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us