Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |