Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
I am trying to write a formula that will look at another cell and populate an
answer depending on what is in the other cell. For instance: in cell D28 is either a number from 1 to 10 or the letters TBD. I want excel to look at that cell and if the number is from 8 - 10 I want it to populate "Successful" in cell D29 if the number in D28 is between 6 - 7.9 I want it to populuate "Needs Improvement" in cell D29 if the number in D28 is less than 6 I want it to populate "Unsuccessful" in cell D29 If it states TBD in cell D28 I want it to populate TBD in cell D29 I was successful in writing the formula for the range of numbers, but the twist seems to be the TBD part. So far my formala is like this: =IF(D148,"Successful",IF(D146,"Needs Improvement",IF(D140,"Unsuccessful"))) Any suggestions on adding the TBD part to this formula? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
Kris,
=IF(D14<"", IF(D14="TBD","TBD",IF(D148,"Successful",IF(D146, "Needs Improvement",IF(D140,"Unsuccessful","Invalid")))) ,"") -- HTH, Bernie MS Excel MVP "Kris" wrote in message ... I am trying to write a formula that will look at another cell and populate an answer depending on what is in the other cell. For instance: in cell D28 is either a number from 1 to 10 or the letters TBD. I want excel to look at that cell and if the number is from 8 - 10 I want it to populate "Successful" in cell D29 if the number in D28 is between 6 - 7.9 I want it to populuate "Needs Improvement" in cell D29 if the number in D28 is less than 6 I want it to populate "Unsuccessful" in cell D29 If it states TBD in cell D28 I want it to populate TBD in cell D29 I was successful in writing the formula for the range of numbers, but the twist seems to be the TBD part. So far my formala is like this: =IF(D148,"Successful",IF(D146,"Needs Improvement",IF(D140,"Unsuccessful"))) Any suggestions on adding the TBD part to this formula? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
Thanks Bernie, this did work, but can you explain what the first part of the
formula you typed in is doing? I am referring to the =IF(D14<"", Thanks! Kris "Bernie Deitrick" wrote: Kris, =IF(D14<"", IF(D14="TBD","TBD",IF(D148,"Successful",IF(D146, "Needs Improvement",IF(D140,"Unsuccessful","Invalid")))) ,"") -- HTH, Bernie MS Excel MVP "Kris" wrote in message ... I am trying to write a formula that will look at another cell and populate an answer depending on what is in the other cell. For instance: in cell D28 is either a number from 1 to 10 or the letters TBD. I want excel to look at that cell and if the number is from 8 - 10 I want it to populate "Successful" in cell D29 if the number in D28 is between 6 - 7.9 I want it to populuate "Needs Improvement" in cell D29 if the number in D28 is less than 6 I want it to populate "Unsuccessful" in cell D29 If it states TBD in cell D28 I want it to populate TBD in cell D29 I was successful in writing the formula for the range of numbers, but the twist seems to be the TBD part. So far my formala is like this: =IF(D148,"Successful",IF(D146,"Needs Improvement",IF(D140,"Unsuccessful"))) Any suggestions on adding the TBD part to this formula? Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
Kris,
It checks to see if the cell is blank, and if it isn't, it checks for the other values - if it is blank, it returns a blank. There are other checks that you could add - for example, if you mis-type TBD as TDB, you will get "Successful" - so you could add a check for that as well: =IF(D14<"", IF(D14="TBD","TBD",IF(NOT(ISNUMBER(D14)),"Invalid String",IF(D148,"Successful",IF(D146,"Needs Improvement",IF(D140,"Unsuccessful","Invalid Number"))))),"") HTH, Bernie MS Excel MVP "Kris" wrote in message ... Thanks Bernie, this did work, but can you explain what the first part of the formula you typed in is doing? I am referring to the =IF(D14<"", Thanks! Kris "Bernie Deitrick" wrote: Kris, =IF(D14<"", IF(D14="TBD","TBD",IF(D148,"Successful",IF(D146, "Needs Improvement",IF(D140,"Unsuccessful","Invalid")))) ,"") -- HTH, Bernie MS Excel MVP "Kris" wrote in message ... I am trying to write a formula that will look at another cell and populate an answer depending on what is in the other cell. For instance: in cell D28 is either a number from 1 to 10 or the letters TBD. I want excel to look at that cell and if the number is from 8 - 10 I want it to populate "Successful" in cell D29 if the number in D28 is between 6 - 7.9 I want it to populuate "Needs Improvement" in cell D29 if the number in D28 is less than 6 I want it to populate "Unsuccessful" in cell D29 If it states TBD in cell D28 I want it to populate TBD in cell D29 I was successful in writing the formula for the range of numbers, but the twist seems to be the TBD part. So far my formala is like this: =IF(D148,"Successful",IF(D146,"Needs Improvement",IF(D140,"Unsuccessful"))) Any suggestions on adding the TBD part to this formula? Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
ok, that helps, but let me add another twist to it.
Suppose I only want it to calculate "Successful" if the value is between 8 and 10, if someone types in any value over 10, I want it to show invalid, can I add this as well? "Bernie Deitrick" wrote: Kris, It checks to see if the cell is blank, and if it isn't, it checks for the other values - if it is blank, it returns a blank. There are other checks that you could add - for example, if you mis-type TBD as TDB, you will get "Successful" - so you could add a check for that as well: =IF(D14<"", IF(D14="TBD","TBD",IF(NOT(ISNUMBER(D14)),"Invalid String",IF(D148,"Successful",IF(D146,"Needs Improvement",IF(D140,"Unsuccessful","Invalid Number"))))),"") HTH, Bernie MS Excel MVP "Kris" wrote in message ... Thanks Bernie, this did work, but can you explain what the first part of the formula you typed in is doing? I am referring to the =IF(D14<"", Thanks! Kris "Bernie Deitrick" wrote: Kris, =IF(D14<"", IF(D14="TBD","TBD",IF(D148,"Successful",IF(D146, "Needs Improvement",IF(D140,"Unsuccessful","Invalid")))) ,"") -- HTH, Bernie MS Excel MVP "Kris" wrote in message ... I am trying to write a formula that will look at another cell and populate an answer depending on what is in the other cell. For instance: in cell D28 is either a number from 1 to 10 or the letters TBD. I want excel to look at that cell and if the number is from 8 - 10 I want it to populate "Successful" in cell D29 if the number in D28 is between 6 - 7.9 I want it to populuate "Needs Improvement" in cell D29 if the number in D28 is less than 6 I want it to populate "Unsuccessful" in cell D29 If it states TBD in cell D28 I want it to populate TBD in cell D29 I was successful in writing the formula for the range of numbers, but the twist seems to be the TBD part. So far my formala is like this: =IF(D148,"Successful",IF(D146,"Needs Improvement",IF(D140,"Unsuccessful"))) Any suggestions on adding the TBD part to this formula? Thanks |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
Of course! Like so:
=IF(D14<"", IF(D14="TBD","TBD",IF(NOT(ISNUMBER(D14)),"Invalid String",IF(D1410,"Too High!",IF(D148,"Successful",IF(D146,"Needs Improvement",IF(D140,"Unsuccessful","Too low!")))))),"") HTH, Bernie MS Excel MVP "Kris" wrote in message ... ok, that helps, but let me add another twist to it. Suppose I only want it to calculate "Successful" if the value is between 8 and 10, if someone types in any value over 10, I want it to show invalid, can I add this as well? "Bernie Deitrick" wrote: Kris, It checks to see if the cell is blank, and if it isn't, it checks for the other values - if it is blank, it returns a blank. There are other checks that you could add - for example, if you mis-type TBD as TDB, you will get "Successful" - so you could add a check for that as well: =IF(D14<"", IF(D14="TBD","TBD",IF(NOT(ISNUMBER(D14)),"Invalid String",IF(D148,"Successful",IF(D146,"Needs Improvement",IF(D140,"Unsuccessful","Invalid Number"))))),"") HTH, Bernie MS Excel MVP "Kris" wrote in message ... Thanks Bernie, this did work, but can you explain what the first part of the formula you typed in is doing? I am referring to the =IF(D14<"", Thanks! Kris "Bernie Deitrick" wrote: Kris, =IF(D14<"", IF(D14="TBD","TBD",IF(D148,"Successful",IF(D146, "Needs Improvement",IF(D140,"Unsuccessful","Invalid")))) ,"") -- HTH, Bernie MS Excel MVP "Kris" wrote in message ... I am trying to write a formula that will look at another cell and populate an answer depending on what is in the other cell. For instance: in cell D28 is either a number from 1 to 10 or the letters TBD. I want excel to look at that cell and if the number is from 8 - 10 I want it to populate "Successful" in cell D29 if the number in D28 is between 6 - 7.9 I want it to populuate "Needs Improvement" in cell D29 if the number in D28 is less than 6 I want it to populate "Unsuccessful" in cell D29 If it states TBD in cell D28 I want it to populate TBD in cell D29 I was successful in writing the formula for the range of numbers, but the twist seems to be the TBD part. So far my formala is like this: =IF(D148,"Successful",IF(D146,"Needs Improvement",IF(D140,"Unsuccessful"))) Any suggestions on adding the TBD part to this formula? Thanks |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
Thanks Bernie, it worked like a charm!
"Bernie Deitrick" wrote: Of course! Like so: =IF(D14<"", IF(D14="TBD","TBD",IF(NOT(ISNUMBER(D14)),"Invalid String",IF(D1410,"Too High!",IF(D148,"Successful",IF(D146,"Needs Improvement",IF(D140,"Unsuccessful","Too low!")))))),"") HTH, Bernie MS Excel MVP "Kris" wrote in message ... ok, that helps, but let me add another twist to it. Suppose I only want it to calculate "Successful" if the value is between 8 and 10, if someone types in any value over 10, I want it to show invalid, can I add this as well? "Bernie Deitrick" wrote: Kris, It checks to see if the cell is blank, and if it isn't, it checks for the other values - if it is blank, it returns a blank. There are other checks that you could add - for example, if you mis-type TBD as TDB, you will get "Successful" - so you could add a check for that as well: =IF(D14<"", IF(D14="TBD","TBD",IF(NOT(ISNUMBER(D14)),"Invalid String",IF(D148,"Successful",IF(D146,"Needs Improvement",IF(D140,"Unsuccessful","Invalid Number"))))),"") HTH, Bernie MS Excel MVP "Kris" wrote in message ... Thanks Bernie, this did work, but can you explain what the first part of the formula you typed in is doing? I am referring to the =IF(D14<"", Thanks! Kris "Bernie Deitrick" wrote: Kris, =IF(D14<"", IF(D14="TBD","TBD",IF(D148,"Successful",IF(D146, "Needs Improvement",IF(D140,"Unsuccessful","Invalid")))) ,"") -- HTH, Bernie MS Excel MVP "Kris" wrote in message ... I am trying to write a formula that will look at another cell and populate an answer depending on what is in the other cell. For instance: in cell D28 is either a number from 1 to 10 or the letters TBD. I want excel to look at that cell and if the number is from 8 - 10 I want it to populate "Successful" in cell D29 if the number in D28 is between 6 - 7.9 I want it to populuate "Needs Improvement" in cell D29 if the number in D28 is less than 6 I want it to populate "Unsuccessful" in cell D29 If it states TBD in cell D28 I want it to populate TBD in cell D29 I was successful in writing the formula for the range of numbers, but the twist seems to be the TBD part. So far my formala is like this: =IF(D148,"Successful",IF(D146,"Needs Improvement",IF(D140,"Unsuccessful"))) Any suggestions on adding the TBD part to this formula? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|