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