| 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... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Shortin my current formula
Hi,
If you had a working formula you would have been better posting it. Does this help? =IF(SUM(B4:M4)=1,"Do This",IF(SUM(B4:M4)=2,"Do That",IF(SUM(B4:M4)=3,"Do the other","None of the above"))) Mike "TheKickerDude" wrote: 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... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Shortin my current formula
Here is the one that works like I need it to:
=IF(B3+C3+D3+E3+F3+M3+G3+I3+H3+J3+K3+L3<20,"Way too many missed!",IF(B3++D3+E3++G3+H3+I3+J3+K3+L3+M323,"Cl ose to Perfect",IF(B3+C3+D3+E3+F3+G3+H3+I3+J3+K3+L3+M3=22 ,"Close to Perfect",IF(B3+C3+D3+E3+F3+G3+H3+I3+J3+K3+L3+M3=24 ,"Perfect","Missed to Many")))) Here is the copy that I"m trying to perfect: =IF(SUM(B4:M4)<20,"Way too many missed!",IF(SUM(B4:M4)23,"Close to Perfect",IF(SUM(B4:M4)=22,"Close to Perfect",IF(SUM(B4:M4)24,"Perfect","Missed to Many")))) Thanks "Mike H" wrote: Hi, If you had a working formula you would have been better posting it. Does this help? =IF(SUM(B4:M4)=1,"Do This",IF(SUM(B4:M4)=2,"Do That",IF(SUM(B4:M4)=3,"Do the other","None of the above"))) Mike "TheKickerDude" wrote: 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... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Shortin my current formula
Ok nevermind I kept tinkering with it, thank you newayz. this is the final
product: =IF(SUM(B4:M4)<20,"Way too many missed!",IF(SUM(B4:M4)=22,"Close to Perfect",IF(SUM(B4:M4)=24,"Perfect","Missed to Many"))) I was creating a perfect attendance for a meeting that you received 2 hours for each meeting once a year with a total of 24 hours attended. "TheKickerDude" wrote: Here is the one that works like I need it to: =IF(B3+C3+D3+E3+F3+M3+G3+I3+H3+J3+K3+L3<20,"Way too many missed!",IF(B3++D3+E3++G3+H3+I3+J3+K3+L3+M323,"Cl ose to Perfect",IF(B3+C3+D3+E3+F3+G3+H3+I3+J3+K3+L3+M3=22 ,"Close to Perfect",IF(B3+C3+D3+E3+F3+G3+H3+I3+J3+K3+L3+M3=24 ,"Perfect","Missed to Many")))) Here is the copy that I"m trying to perfect: =IF(SUM(B4:M4)<20,"Way too many missed!",IF(SUM(B4:M4)23,"Close to Perfect",IF(SUM(B4:M4)=22,"Close to Perfect",IF(SUM(B4:M4)24,"Perfect","Missed to Many")))) Thanks "Mike H" wrote: Hi, If you had a working formula you would have been better posting it. Does this help? =IF(SUM(B4:M4)=1,"Do This",IF(SUM(B4:M4)=2,"Do That",IF(SUM(B4:M4)=3,"Do the other","None of the above"))) Mike "TheKickerDude" wrote: 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... |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Shortin my current formula
Hi,
What happens if the score is 21? can it go over 24? Mike "TheKickerDude" wrote: Here is the one that works like I need it to: =IF(B3+C3+D3+E3+F3+M3+G3+I3+H3+J3+K3+L3<20,"Way too many missed!",IF(B3++D3+E3++G3+H3+I3+J3+K3+L3+M323,"Cl ose to Perfect",IF(B3+C3+D3+E3+F3+G3+H3+I3+J3+K3+L3+M3=22 ,"Close to Perfect",IF(B3+C3+D3+E3+F3+G3+H3+I3+J3+K3+L3+M3=24 ,"Perfect","Missed to Many")))) Here is the copy that I"m trying to perfect: =IF(SUM(B4:M4)<20,"Way too many missed!",IF(SUM(B4:M4)23,"Close to Perfect",IF(SUM(B4:M4)=22,"Close to Perfect",IF(SUM(B4:M4)24,"Perfect","Missed to Many")))) Thanks "Mike H" wrote: Hi, If you had a working formula you would have been better posting it. Does this help? =IF(SUM(B4:M4)=1,"Do This",IF(SUM(B4:M4)=2,"Do That",IF(SUM(B4:M4)=3,"Do the other","None of the above"))) Mike "TheKickerDude" wrote: 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... |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Shortin my current formula
The way I have it you can only add 2 hours per month or none, so there can
only be a total of 24 per year for each individual. I also added if the total is over 24, "Not Possible" there is a typo somewhere. "Mike H" wrote: Hi, What happens if the score is 21? can it go over 24? Mike "TheKickerDude" wrote: Here is the one that works like I need it to: =IF(B3+C3+D3+E3+F3+M3+G3+I3+H3+J3+K3+L3<20,"Way too many missed!",IF(B3++D3+E3++G3+H3+I3+J3+K3+L3+M323,"Cl ose to Perfect",IF(B3+C3+D3+E3+F3+G3+H3+I3+J3+K3+L3+M3=22 ,"Close to Perfect",IF(B3+C3+D3+E3+F3+G3+H3+I3+J3+K3+L3+M3=24 ,"Perfect","Missed to Many")))) Here is the copy that I"m trying to perfect: =IF(SUM(B4:M4)<20,"Way too many missed!",IF(SUM(B4:M4)23,"Close to Perfect",IF(SUM(B4:M4)=22,"Close to Perfect",IF(SUM(B4:M4)24,"Perfect","Missed to Many")))) Thanks "Mike H" wrote: Hi, If you had a working formula you would have been better posting it. Does this help? =IF(SUM(B4:M4)=1,"Do This",IF(SUM(B4:M4)=2,"Do That",IF(SUM(B4:M4)=3,"Do the other","None of the above"))) Mike "TheKickerDude" wrote: 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... |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Shortin my current formula
Try this
=IF(SUM(B3:L3)<=20,"Way Too many missed",IF(SUM(B3:L3)<=23,"Close to perfect",IF(SUM(B3:L3)=24,"Perfect"))) Mike "TheKickerDude" wrote: The way I have it you can only add 2 hours per month or none, so there can only be a total of 24 per year for each individual. I also added if the total is over 24, "Not Possible" there is a typo somewhere. "Mike H" wrote: Hi, What happens if the score is 21? can it go over 24? Mike "TheKickerDude" wrote: Here is the one that works like I need it to: =IF(B3+C3+D3+E3+F3+M3+G3+I3+H3+J3+K3+L3<20,"Way too many missed!",IF(B3++D3+E3++G3+H3+I3+J3+K3+L3+M323,"Cl ose to Perfect",IF(B3+C3+D3+E3+F3+G3+H3+I3+J3+K3+L3+M3=22 ,"Close to Perfect",IF(B3+C3+D3+E3+F3+G3+H3+I3+J3+K3+L3+M3=24 ,"Perfect","Missed to Many")))) Here is the copy that I"m trying to perfect: =IF(SUM(B4:M4)<20,"Way too many missed!",IF(SUM(B4:M4)23,"Close to Perfect",IF(SUM(B4:M4)=22,"Close to Perfect",IF(SUM(B4:M4)24,"Perfect","Missed to Many")))) Thanks "Mike H" wrote: Hi, If you had a working formula you would have been better posting it. Does this help? =IF(SUM(B4:M4)=1,"Do This",IF(SUM(B4:M4)=2,"Do That",IF(SUM(B4:M4)=3,"Do the other","None of the above"))) Mike "TheKickerDude" wrote: 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... |
| Reply |
| 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 | |||
Hybrid Mode
