Help with a formula please

[raigo]

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(A2>89,"A",IF(A2>79,"B",
IF(A2>69,"C",IF(A2>59,"D","F")))) (it doesnt work, keeps giving errors on
commas)

Thank You

[Bill Ridgeway]

This one works -
=IF(C2>36,10,IF(C2>33,5,IF(C2>31,3,0)))

Regards.

Bill Ridgeway
Computer Solutions

"raigo" <[email protected]> wrote in message
news:[email protected]...
> 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(A2>89,"A",IF(A2>79,"B",
> IF(A2>69,"C",IF(A2>59,"D","F")))) (it doesnt work, keeps giving errors on
> commas)
>
> Thank You

[Adrian G]

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.

=(C2>30)*3+(C2>32)*2+(C2>35)*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