| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help, help! desparate for formula help!!
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help, help! desparate for formula help!!
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help, help! desparate for formula help!!
=IF(SUM(C4:O4)40,SUM(C4:O4)-40,0)
-- Regards Dave Hawley www.ozgrid.com "How do I?" <How do wrote in message ... 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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help, help! desparate for formula help!!
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Desparate For Help - Pivot Table Field List | Excel Discussion (Misc queries) | |||
| Desparate..please help | Excel Worksheet Functions | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
| Help - desparate for an expanded history log without sharing a workbook | Excel Programming | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Hybrid Mode
