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

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

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

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

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

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

Shortin my current formula
 

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"})

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"TheKickerDude" wrote in message
...
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...

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

Shortin my current formula
 

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.

"Mike H" wrote:

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