Help with a formula please
 

Hello, i am trying to make a aformula that would put 3 as cell value if the
data is between 31 and 33, put 5 if data is between 33 and 36 and would put
10 if data is over 36 and 0 if data is below 33. I copied the formula from
excel help file, changed nothing and it didnt work in the forst place. I had
to replace all commas with semicolons then it kinda worked. But it only
counts the first condition now. Help please :)

=IF(C2=31;"3";IF(C2=33;"5"; IF(C2=36;"10";"0")))


Original Formula from excel help: =IF(A289,"A",IF(A279,"B",
IF(A269,"C",IF(A259,"D","F")))) (it doesnt work, keeps giving errors on
commas)

Thank You

Help with a formula please
 

This one works -
=IF(C236,10,IF(C233,5,IF(C231,3,0)))

Regards.

Bill Ridgeway
Computer Solutions

"raigo" wrote in message
...
Hello, i am trying to make a aformula that would put 3 as cell value if
the
data is between 31 and 33, put 5 if data is between 33 and 36 and would
put
10 if data is over 36 and 0 if data is below 33. I copied the formula from
excel help file, changed nothing and it didnt work in the forst place. I
had
to replace all commas with semicolons then it kinda worked. But it only
counts the first condition now. Help please :)

=IF(C2=31;"3";IF(C2=33;"5"; IF(C2=36;"10";"0")))


Original Formula from excel help: =IF(A289,"A",IF(A279,"B",
IF(A269,"C",IF(A259,"D","F")))) (it doesnt work, keeps giving errors on
commas)

Thank You

Help with a formula please
 

I'm not sure the text of your query is completely consistent with the
result I infer from your formula, but the following will give the step
result you are looking for I think.

=(C230)*3+(C232)*2+(C235)*5

The Excel IF statement has its uses, but for anything more than a
simple choice between two options, if the result is numerical, this
approach is easier to follow and, I suspect, executes faster.

Adrian


--
Adrian G
------------------------------------------------------------------------
Adrian G's Profile: http://www.excelforum.com/member.php...o&userid=36629
View this thread: http://www.excelforum.com/showthread...hreadid=567042