Thread: Excel Question #46
View Single Post
Old 02-16-2012, 03:36 PM   #84
Betty
Kicking up my heels!
 
Betty's Avatar
 
Join Date: Jan 2005
Location: The Silver State
Posts: 3,783
Betty is the epitome of coolBetty is the epitome of coolBetty is the epitome of coolBetty is the epitome of coolBetty is the epitome of coolBetty is the epitome of coolBetty is the epitome of coolBetty is the epitome of coolBetty is the epitome of coolBetty is the epitome of coolBetty is the epitome of cool
Quote:
Originally Posted by Moonliner View Post
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!
__________________
Nee Stell Thue
Betty is offline   Submit to Quotes Reply With Quote