Help with a formula please

[Guest]

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

 

[Bob Phillips]

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


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Niek Otten]

Change the order in which you test: first test for >=36, etc. (Because if a cell is 40, it is >=31 so it will satisfy your present
first test)

Commas or semicolons is a matter of local settings for list separators.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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