Posted to microsoft.public.excel.misc

confused

external usenet poster

Posts: 193

Would I use an "If and" statement?

I have a table as shown.

Column A Column B
Y
???? Y
???? Y
???? Y

I need a formula says if Column B = Y, then return 1 only if the sum of all
previous cells in column A is less than 25. if greater than 25, then 2. And
if all of 1 and 2 is greater than 50, then 3, and if all of 1, 2, 3 is
greater than 74, then 4.

Then I need a formula that will say, if

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
how do I write an "if then" statement in Excel. eg. If L47 = 0 the	dxrok	Excel Worksheet Functions	1	August 5th 06 10:28 PM
"IF AND" statement	Buddy Roe	Excel Worksheet Functions	2	July 14th 06 04:39 PM
CREATE AN "IF' STATEMENT FOR CHOICES OF CHECK BOXES	pjb	Excel Worksheet Functions	7	May 8th 06 08:57 PM
If statement	Matt Montagliano	Excel Discussion (Misc queries)	1	September 8th 05 08:47 PM
Do I need a sumif or sum of a vlookup formula?	PeterB	Excel Worksheet Functions	0	June 1st 05 12:23 PM

All times are GMT +1. The time now is 04:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us