Put an if statement inside an if statement

So instead of

=If(A1=1,235234,0)

you have

=If(A1=1,if(b1=3,5,4),0)

Which says......

If A1 = 1 And B1 = 3 put 5
If A1 = 1 And B1 3 put 4
If A1 1 then put 0

You can embed up to 7 levels of if.

Then sum and count.

If you have hundreds of combinations, look up pivot tables.

Posted By: BeverlyHills0201 on February 22nd 2006 at 14:31:24

Message Thread

Non footy i'm afraid - Excel help required... (General Chat) - Yellalee, Feb 22, 14:06:45
- Tuck your 'ifs' in after you've taken them up the wooden hill to Bedfordshire (n/m) (General Chat) - malkybarkid, Feb 22, 14:44:51
- Embed your Ifs innit (n/m) (General Chat) - Steve in Holland, Feb 22, 14:18:42
- Yep, Embed your Ifs. And then use conditional formatting. (n/m) (General Chat) - Arganth, Feb 22, 14:14:44
- Sounds like you need to embed if statements. (n/m) (General Chat) - BeverlyHills0201, Feb 22, 14:11:13
  - What does that mean? Never had to bed and 'if' before... (General Chat) - Yellalee, Feb 22, 14:26:50
    - Put an if statement inside an if statement (General Chat) - BeverlyHills0201, Feb 22, 14:31:24
      - cheers... i think ive got that... (n/m) (General Chat) - Yellalee, Feb 22, 14:33:43
    - *an* (n/m) (General Chat) - Yellalee, Feb 22, 14:27:14
  - Or even a pivot table. (n/m) (General Chat) - BeverlyHills0201, Feb 22, 14:13:58

Reply to Message

In order to add a post to the WotB Message Board you must be a registered WotB user.

If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.