Posted to microsoft.public.excel.misc

Dave in Ampthill[_2_] Dave in Ampthill[_2_] is offline

external usenet poster

Posts: 10

IF statements

Hi,

I have a column of cells ranging from F46 to F51

I want cell F51 to be the sum of F46:F50 with the following conditions:

If SUM(F46:F50) = 0 then F51 to read 0
If SUM(F46:F50)<200 then F51 to read 200
If SUM(F46:F50)200 then F51 to show actual sum of F46:F50

How do I write this as a formula?

Many thanks in advance,

Dave

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
Help with IF statements	Lil	Excel Worksheet Functions	0	May 4th 07 06:02 AM
If Statements	Motaad	Excel Worksheet Functions	2	April 16th 07 05:50 PM
if statements	SB777	Excel Worksheet Functions	3	April 13th 07 06:42 PM
IF Statements (Mutliple Statements)	Deezel	Excel Worksheet Functions	3	October 19th 06 06:13 AM
If statements	paule1982	Excel Discussion (Misc queries)	4	February 18th 06 05:09 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us