Excel Question #46

Alex · 02-16-2012, 03:16 PM

Oh there were two pictures.

Ok, in cell G5 the problem is that you have the SUM going C4:F4 instead of B4:F4. With what you have you end up asking "what is the minimum of 8, 8, and 8).

Once you fix that sum you're going to get 0 in G5.

Betty · 02-16-2012, 03:21 PM

Quote:

Originally Posted by Alex

Oh there were two pictures.

Ok, in cell G5 the problem is that you have the SUM going C4:F4 instead of B4:F4. With what you have you end up asking "what is the minimum of 8, 8, and 8).

Once you fix that sum you're going to get 0 in G5.

Cell G5 is =IF(SUM(C5:F5)<40,MIN(MIN(8,40-SUM(C5:F5)),G4),0)

I'm not seeing C4:F4 - or am I missing something.

Moonliner · 02-16-2012, 03:27 PM

Quote:

Originally Posted by Betty

Cell G5 is =IF(SUM(C5:F5)<40,MIN(MIN(8,40-SUM(C5:F5)),G4),0)

I'm not seeing C4:F4 - or am I missing something.

Cell G5 should read: is =IF(SUM(B5:F5)<40,MIN(MIN(8,40-SUM(B5:F5)),G4),0)

What is the formula for cell G6 and G7?

Betty · 02-16-2012, 03:36 PM

Quote:

Originally Posted by Moonliner

Cell G5 should read: is =IF(SUM(B5:F5)<40,MIN(MIN(8,40-SUM(B5:F5)),G4),0)

What is the formula for cell G6 and G7?

There we go! Yay!

Moonliner · 02-16-2012, 04:04 PM

Quote:

Originally Posted by Betty

There we go! Yay!

You probably already figured this out, but you need to make the same change to cells G13 and G21

Betty · 02-16-2012, 04:12 PM

Quote:

Originally Posted by Moonliner

You probably already figured this out, but you need to make the same change to cells G13 and G21

Thanks.

Moonliner · 10-05-2012, 10:24 AM

I was assigned a "high priority" task today. A "You are to work on nothing but this for the new few days" thing.

The task is to match up some data in a couple of overly large excel spreadsheets.

So I imported the data into SQL Server and created a couple of cross table queries to pull the needed data and drop it back into excel. Total time: ~45min.

So my question is, what's good on Netflix? I have a few days to kill.....

02-16-2012, 03:16 PM	#1
Alex . Join Date: Feb 2005 Posts: 13,354	Oh there were two pictures. Ok, in cell G5 the problem is that you have the SUM going C4:F4 instead of B4:F4. With what you have you end up asking "what is the minimum of 8, 8, and 8). Once you fix that sum you're going to get 0 in G5.
	Submit to Quotes

10-05-2012, 10:24 AM	#7
Moonliner 8/30/14 - Disneyland -10k or Bust. Join Date: Jan 2005 Posts: 9,022	I was assigned a "high priority" task today. A "You are to work on nothing but this for the new few days" thing. The task is to match up some data in a couple of overly large excel spreadsheets. So I imported the data into SQL Server and created a couple of cross table queries to pull the needed data and drop it back into excel. Total time: ~45min. So my question is, what's good on Netflix? I have a few days to kill..... __________________ - Taking it one step at a time.
	Submit to Quotes