Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My IF in Excel formula is not returning the correct value.
I am doing a reference of 1, 2, or 3 returning specific text based on the
number. Here is my formula. =IF(G29=1,"DOES NOT MEET",IF(G29=2,"CONSISTENTLY MEETS",IF(G29=3,"EXCEEDS"))) if the ratings are all 3's the correct text value will appear. If you vary the ratings I receive a false value. Can anyone help me. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My IF in Excel formula is not returning the correct value.
Steph wrote:
I am doing a reference of 1, 2, or 3 returning specific text based on the number. Here is my formula. =IF(G29=1,"DOES NOT MEET",IF(G29=2,"CONSISTENTLY MEETS",IF(G29=3,"EXCEEDS"))) if the ratings are all 3's the correct text value will appear. If you vary the ratings I receive a false value. Can anyone help me. Hi Steph, I'm not sure to have well understood, but try this: =IF(G29=1,"DOES NOT MEET",IF(G29=2,"CONSISTENTLY MEETS",IF(G29=3,"EXCEEDS",""))) -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My IF in Excel formula is not returning the correct value.
Steph, try this,
=IF(G29=1,"DOES NOT MEET",IF(G29=2,"CONSISTENTLY MEETS",IF(G29=3,"EXCEEDS",""))) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Steph" wrote in message ... I am doing a reference of 1, 2, or 3 returning specific text based on the number. Here is my formula. =IF(G29=1,"DOES NOT MEET",IF(G29=2,"CONSISTENTLY MEETS",IF(G29=3,"EXCEEDS"))) if the ratings are all 3's the correct text value will appear. If you vary the ratings I receive a false value. Can anyone help me. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My IF in Excel formula is not returning the correct value.
I am doing a reference of 1, 2, or 3 returning specific text based on
the number. Here is my formula. =IF(G29=1,"DOES NOT MEET",IF(G29=2,"CONSISTENTLY MEETS",IF(G29=3,"EXCEEDS"))) if the ratings are all 3's the correct text value will appear. If you vary the ratings I receive a false value. Can anyone help me. I tried your formula, and get (what seems to be) the correct result if G29 is either 1, 2, or 3. If G29 is any other value, I get FALSE because the formula doesn't provide for a result in that case. If you change the formula to provide for other values =IF(G29=1,"DOES NOT MEET", IF(G29=2,"CONSISTENTLY MEETS",IF(G29=3,"EXCEEDS","other"))) it should become clear what's going on. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My IF in Excel formula is not returning the correct value.
Thank you Paul that helped some what. I am still having a problem. Picture
a performance review with a row of 1,2,3 as the points for each cell. At the end the points are all added up and an overall rating is calculated 1,2, or 3. If I key in all 1 the value = does not meet, however if I populate the fields 1, 2, or 3 randomly the value is false or blank with what you proposed. But I was thinking it should not matter what get's me to the cell that I am referencing as long as it equals 1,2,3. Your thoughts? "Steph" wrote: I am doing a reference of 1, 2, or 3 returning specific text based on the number. Here is my formula. =IF(G29=1,"DOES NOT MEET",IF(G29=2,"CONSISTENTLY MEETS",IF(G29=3,"EXCEEDS"))) if the ratings are all 3's the correct text value will appear. If you vary the ratings I receive a false value. Can anyone help me. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My IF in Excel formula is not returning the correct value.
Whats the formula in G29? -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=572873 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My IF in Excel formula is not returning the correct value.
Steph, not sure what you are doing, I can put =A1+A2+A3 in cell G29, or
something else and as long as the formula comes up with 1,2,or 3 the message is displayed. As Bearacade asked what is in cell G29, and maybe how it is formatted, could be showing 1,2,or 3 but the answer may be something like 2.1? -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Steph" wrote in message ... Thank you Paul that helped some what. I am still having a problem. Picture a performance review with a row of 1,2,3 as the points for each cell. At the end the points are all added up and an overall rating is calculated 1,2, or 3. If I key in all 1 the value = does not meet, however if I populate the fields 1, 2, or 3 randomly the value is false or blank with what you proposed. But I was thinking it should not matter what get's me to the cell that I am referencing as long as it equals 1,2,3. Your thoughts? "Steph" wrote: I am doing a reference of 1, 2, or 3 returning specific text based on the number. Here is my formula. =IF(G29=1,"DOES NOT MEET",IF(G29=2,"CONSISTENTLY MEETS",IF(G29=3,"EXCEEDS"))) if the ratings are all 3's the correct text value will appear. If you vary the ratings I receive a false value. Can anyone help me. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My IF in Excel formula is not returning the correct value.
Service Category Rating
Did the associate you spoke with provide great service? 1 How satisfied are you with the purchase you made? 2 How satisfied are you with the transaction process? 3 How likely are you to buy from us again? 2 How likely are you to recommend our company to others? 1 Total Points 2 Performance Rating * *this value should display Consistently Meets but is blank, if they points are all 2 then the value displays consistently meets. It shouldn't matter though since my IF formula is based of the total points of 1,2,3. I did try percision as displayed and now it works but I can not format anything. "Paul B" wrote: Steph, not sure what you are doing, I can put =A1+A2+A3 in cell G29, or something else and as long as the formula comes up with 1,2,or 3 the message is displayed. As Bearacade asked what is in cell G29, and maybe how it is formatted, could be showing 1,2,or 3 but the answer may be something like 2.1? -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Steph" wrote in message ... Thank you Paul that helped some what. I am still having a problem. Picture a performance review with a row of 1,2,3 as the points for each cell. At the end the points are all added up and an overall rating is calculated 1,2, or 3. If I key in all 1 the value = does not meet, however if I populate the fields 1, 2, or 3 randomly the value is false or blank with what you proposed. But I was thinking it should not matter what get's me to the cell that I am referencing as long as it equals 1,2,3. Your thoughts? "Steph" wrote: I am doing a reference of 1, 2, or 3 returning specific text based on the number. Here is my formula. =IF(G29=1,"DOES NOT MEET",IF(G29=2,"CONSISTENTLY MEETS",IF(G29=3,"EXCEEDS"))) if the ratings are all 3's the correct text value will appear. If you vary the ratings I receive a false value. Can anyone help me. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My IF in Excel formula is not returning the correct value.
This is the formula I have in the cell so it should work right?
=IF(G29=1,"DOES NOT MEET",IF(G29=2,"CONSISTENTLY MEETS",IF(G29=3,"EXCEEDS",""))) "Bearacade" wrote: Whats the formula in G29? -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=572873 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My IF in Excel formula is not returning the correct value.
Steph, you can't have that formula in G29, it would be a circular reference,
the cell reference refers the formula's results, you would need to have the formula in another cell and the total points formula in G29, what formula are you using to get the total points from the numbers 1,2,3,2,1? So what cell is the formula in? And what cell is the formula for total points in? and what is that formula? -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Steph" wrote in message ... Service Category Rating Did the associate you spoke with provide great service? 1 How satisfied are you with the purchase you made? 2 How satisfied are you with the transaction process? 3 How likely are you to buy from us again? 2 How likely are you to recommend our company to others? 1 Total Points 2 Performance Rating * *this value should display Consistently Meets but is blank, if they points are all 2 then the value displays consistently meets. It shouldn't matter though since my IF formula is based of the total points of 1,2,3. I did try percision as displayed and now it works but I can not format anything. "Paul B" wrote: Steph, not sure what you are doing, I can put =A1+A2+A3 in cell G29, or something else and as long as the formula comes up with 1,2,or 3 the message is displayed. As Bearacade asked what is in cell G29, and maybe how it is formatted, could be showing 1,2,or 3 but the answer may be something like 2.1? -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Steph" wrote in message ... Thank you Paul that helped some what. I am still having a problem. Picture a performance review with a row of 1,2,3 as the points for each cell. At the end the points are all added up and an overall rating is calculated 1,2, or 3. If I key in all 1 the value = does not meet, however if I populate the fields 1, 2, or 3 randomly the value is false or blank with what you proposed. But I was thinking it should not matter what get's me to the cell that I am referencing as long as it equals 1,2,3. Your thoughts? "Steph" wrote: I am doing a reference of 1, 2, or 3 returning specific text based on the number. Here is my formula. =IF(G29=1,"DOES NOT MEET",IF(G29=2,"CONSISTENTLY MEETS",IF(G29=3,"EXCEEDS"))) if the ratings are all 3's the correct text value will appear. If you vary the ratings I receive a false value. Can anyone help me. |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My IF in Excel formula is not returning the correct value.
Picture a performance review with a row of 1,2,3 as the points for
each cell. At the end the points are all added up and an overall rating is calculated 1,2, or 3. If I key in all 1 the value = does not meet, however if I populate the fields 1, 2, or 3 randomly the value is false or blank with what you proposed. But I was thinking it should not matter what get's me to the cell that I am referencing as long as it equals 1,2,3. Your thoughts? Maybe the CSV file below would help. --------------------- cut here -------------------------- , , , , , , , , , , , , , , , , , , , , , Service Category,,,,,,Rating Did the associate you spoke with provide great service?,,,,,,3 How satisfied are you with the purchase you made?,,,,,,3 How satisfied are you with the transaction process?,,,,,,2 How likely are you to buy from us again?,,,,,,2 How likely are you to recommend our company to others?,,,,,,2 ,,,,,, Total Points,,,,,,"=ROUND(AVERAGE(G23:G28),0)" Performance Rating,,,,,,"=IF(G29=1,""DOES NOT MEET"", IF(G29= 2,""CONSISTENTLY MEETS"",IF(G29=3,""EXCEEDS"",""other"")))" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula Q | Excel Worksheet Functions | |||
Trouble writing an excel formula. | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions |