L
LoveExcelButFrustrated
This is a big one (and a few may follow if I can't figure out the others
based on responses here). I am trying to create a score keeping formula. It
is gender specific for points as well. Here is what I am trying to make the
formula say: if a male gets 2 or less pull ups, its fail and for every one 3
and over is *5 for points. (20 is max for a score of 100.) Now for females,
they do a flex arm hang for 4 seconds or less and fail it or 5 or more
seconds to pass. 5 to 40 seconds are equivalent to on point each but then
after 40 they go by 2's so that 41=42, 42=44, 43=46, etc.. until 70 seconds
which equals 100 points. The basics of the first formula i.e.
=IF(S8<=2,"Fail",S8*5) I got to work, but then can't figure out how to make
it gender specific. My cell M8 is where the M or F goes for gender but when I
try any variation of =IF(M8="M";(S8<=2,"Fail",S8*5) it tells me that that is
invalid, or cannot find library such and such... I have been at this all day
and can't get it. Can anyone help? Don't forget I also need it to say if
M8="F" then blah blah blah in the same formula for those scores. I know it
can be done because I am mirroring a form I already have that uses these
formulas, but guess what? It is protected! HA HA. And the person who made it
left this unit years ago and no one knows who it was or what the password
might be so that I can edit the OTHER fields that aren't acceptible. So if
anyone can tell me how to unprotect this worksheet that would be waaaayyy
easier. Enough for now, can anyone give me a hand?
based on responses here). I am trying to create a score keeping formula. It
is gender specific for points as well. Here is what I am trying to make the
formula say: if a male gets 2 or less pull ups, its fail and for every one 3
and over is *5 for points. (20 is max for a score of 100.) Now for females,
they do a flex arm hang for 4 seconds or less and fail it or 5 or more
seconds to pass. 5 to 40 seconds are equivalent to on point each but then
after 40 they go by 2's so that 41=42, 42=44, 43=46, etc.. until 70 seconds
which equals 100 points. The basics of the first formula i.e.
=IF(S8<=2,"Fail",S8*5) I got to work, but then can't figure out how to make
it gender specific. My cell M8 is where the M or F goes for gender but when I
try any variation of =IF(M8="M";(S8<=2,"Fail",S8*5) it tells me that that is
invalid, or cannot find library such and such... I have been at this all day
and can't get it. Can anyone help? Don't forget I also need it to say if
M8="F" then blah blah blah in the same formula for those scores. I know it
can be done because I am mirroring a form I already have that uses these
formulas, but guess what? It is protected! HA HA. And the person who made it
left this unit years ago and no one knows who it was or what the password
might be so that I can edit the OTHER fields that aren't acceptible. So if
anyone can tell me how to unprotect this worksheet that would be waaaayyy
easier. Enough for now, can anyone give me a hand?