Nested IF statements

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karrisac15 - 19 Jul 2007 19:34 GMT

I have a series of numbers in excel that i would like to group as soon as
they add up to =>1. For example A1 & A2 do not ad up to be >1 but sum(A1:A3)
does. Therefore I would like it to say "Group A1, A2 & A3". After it groups
A1, A2, and A3 I would like it to start over with A4. Here is the problem:
I do not know how to nest IF statements for all conditions such as if A1 & A2
actually added up to =>1 I would want it to start a over with A3 instead of
A4.
A
1 0.33126935
2 0.191950464
3 2.278947368
4 0.520123839
5 0.693188854
6 0.073374613
7 0.164086687

Reply to this Message

Mike H - 19 Jul 2007 20:06 GMT

Hi,

try this
Col A Col B
0.33127 =A1
0.191950464 =IF(B1<=1,B1+A2,A2)
2.278947368
0.520123839
0.693188854
0.073374613

In b1 enter the formula =A1
In B2 enter the formula shown above and drag down.
It will sum column A until Greater than 1 then start again

Mike

uk

> I have a series of numbers in excel that i would like to group as soon as
> they add up to =>1. For example A1 & A2 do not ad up to be >1 but sum(A1:A3)
[quoted text clipped - 11 lines]
> 6 0.073374613
> 7 0.164086687

Reply to this Message

Rate this thread: