| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shortin my current formula
OK I have the formula working correctly but I'm trying to use the sum
function to sum the cells B4:M4 and while in the IF statement instead of typing IF(B4+C4+D4 and so on.. like IF(Sum(B4:M4 or something like that. I'm nesting like 4 other IF functions into one cell. I just don't like the sight of a million characters in one cell. Any help? If not possible I will live with it I guess... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using the current row in a formula | Excel Worksheet Functions | |||
| current date formula | Excel Discussion (Misc queries) | |||
| formula help need to get current row | Excel Worksheet Functions | |||
| Can I automatically enter the current date or current time into a | New Users to Excel | |||
| Formula with current Date | Excel Worksheet Functions | |||
Threaded Mode
