in [Programming]

Prev: Initialise the registry values in a array and retrive the values as required
Next: Multiple reference locking/unlockng in formulas
From: How do I? How do on 26 Apr 2010 06:50 I need somone to tell me a formula to copy and paste into a cell in my excel worksheet. I need this for work today! Can't figure it out. Here's what I need: If SUM(C4:O4) is greater than 40, then SUM(C4:O4)-40, but if SUM(C4:O4)is equal or less than 40, then 0 Now how the heck do I make a formula with that? Please help!
From: Jacob Skaria on 26 Apr 2010 06:54 Try =IF(SUM(C4:O4)>40,SUM(C4:O4)-40,0) -- Jacob (MVP - Excel) "How do I?" wrote: > I need somone to tell me a formula to copy and paste into a cell in my excel > worksheet. I need this for work today! Can't figure it out. Here's what I > need: > If SUM(C4:O4) is greater than 40, then SUM(C4:O4)-40, but if SUM(C4:O4)is > equal or less than 40, then 0 > Now how the heck do I make a formula with that? Please help!
From: ozgrid.com on 26 Apr 2010 06:55 =IF(SUM(C4:O4)>40,SUM(C4:O4)-40,0) -- Regards Dave Hawley www.ozgrid.com "How do I?" <How do I?@discussions.microsoft.com> wrote in message news:C3E55085-0C53-473E-82C2-1487DAFD5527 (a)microsoft.com...>I need somone to tell me a formula to copy and paste into a cell in my >excel > worksheet. I need this for work today! Can't figure it out. Here's what > I > need: > If SUM(C4:O4) is greater than 40, then SUM(C4:O4)-40, but if SUM(C4:O4)is > equal or less than 40, then 0 > Now how the heck do I make a formula with that? Please help!
From: Mike H on 26 Apr 2010 07:19
Hi, IF statements aren't necessary, try this =MAX(0,SUM(C4:O4)-40) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "How do I?" wrote: > I need somone to tell me a formula to copy and paste into a cell in my excel > worksheet. I need this for work today! Can't figure it out. Here's what I > need: > If SUM(C4:O4) is greater than 40, then SUM(C4:O4)-40, but if SUM(C4:O4)is > equal or less than 40, then 0 > Now how the heck do I make a formula with that? Please help! |