Shortin my current formula

[TheKickerDude]

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...

 

[Mike H]

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]

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+M3>23,"Close 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

 

[TheKickerDude]

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.

 

[Mike H]

Hi,

What happens if the score is 21? can it go over 24?

Mike

 

[TheKickerDude]

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.

 

[Don Guillett]

I also am not quite sure what you want. Try tinkering with this
=LOOKUP(SUM(B4:M4),{0,20,22,24;"missedA","missedB","close","perfect"})

 

[Mike H]

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]

I got it working correctly.

=IF(SUM(B4:M4)>24,"Not Possible",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"))))

Type Jan-Dec starting from B43:M3 and apply the formula to cell N4
then type 2 hours for each month starting from Jan-Dec or any order and this
is what I was wanting. Thanks to all.