Thread: Excel Question #46
View Single Post
Old 02-16-2012, 03:27 PM   #79
Moonliner
8/30/14 - Disneyland -10k or Bust.
 
Moonliner's Avatar
 
Join Date: Jan 2005
Posts: 9,022
Moonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of cool
Send a message via AIM to Moonliner Send a message via MSN to Moonliner Send a message via Yahoo to Moonliner
Quote:
Originally Posted by Betty View Post
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?
__________________
- Taking it one step at a time.
Moonliner is offline   Submit to Quotes Reply With Quote