| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding text to an IF statement effeciently
I have the following code in a cell on Sheet A:
=IF(E41H41,"Rock on, Man! You are EXCEEDING your Stretch goal for the month!",IF(E41=H41,"Nice work! You are meeting your stretch goal for the month!",IF(E41=G41,"Great work. You are meeting your Target goal.",IF(E41=F41,"You are meeting Threshold. Which is the bare minimum.",IF(E41<F41,"Um... so yeah... you might want to do some work, Dude."))))) What I would like to do is assign each quote to a variable on Sheet B like such: exceed = "Rock on, Man! You are EXCEEDING your Stretch goal for the month!" stretch = "Nice work! You are meeting your stretch goal for the month!" target = "Great work. You are meeting your Target goal." threshold = "You are meeting Threshold. Which is the bare minimum." slack = "Um... so yeah... you might want to do some work, Dude." And I would like to replace the code above with something like this: =IF(E41H41,exceed,IF(E41=H41,stretch,IF(E41=G41 ,target,IF(E41=F41,threshold,IF(E41<F41,slack)))) ) What is the correct syntax to make this work? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding text to an IF statement effeciently
You can do that with Named Ranges. Named ranges return cell references
typically but there is no reason why it can not return a text string. Try this... Insert | Name | Define Under names in this workbook: Add Exceed Under Refers to: add = "Rock on, Man! You are EXCEEDING your Stretch goal for the month!" Now in a cell type the formula =Exceed You can also use Exceed in your formulas just as you posted... -- HTH... Jim Thomlinson "Bishop" wrote: I have the following code in a cell on Sheet A: =IF(E41H41,"Rock on, Man! You are EXCEEDING your Stretch goal for the month!",IF(E41=H41,"Nice work! You are meeting your stretch goal for the month!",IF(E41=G41,"Great work. You are meeting your Target goal.",IF(E41=F41,"You are meeting Threshold. Which is the bare minimum.",IF(E41<F41,"Um... so yeah... you might want to do some work, Dude."))))) What I would like to do is assign each quote to a variable on Sheet B like such: exceed = "Rock on, Man! You are EXCEEDING your Stretch goal for the month!" stretch = "Nice work! You are meeting your stretch goal for the month!" target = "Great work. You are meeting your Target goal." threshold = "You are meeting Threshold. Which is the bare minimum." slack = "Um... so yeah... you might want to do some work, Dude." And I would like to replace the code above with something like this: =IF(E41H41,exceed,IF(E41=H41,stretch,IF(E41=G41 ,target,IF(E41=F41,threshold,IF(E41<F41,slack)))) ) What is the correct syntax to make this work? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding text to an IF statement effeciently
Exactly what I was looking for. Thank you!
"Jim Thomlinson" wrote: You can do that with Named Ranges. Named ranges return cell references typically but there is no reason why it can not return a text string. Try this... Insert | Name | Define Under names in this workbook: Add Exceed Under Refers to: add = "Rock on, Man! You are EXCEEDING your Stretch goal for the month!" Now in a cell type the formula =Exceed You can also use Exceed in your formulas just as you posted... -- HTH... Jim Thomlinson "Bishop" wrote: I have the following code in a cell on Sheet A: =IF(E41H41,"Rock on, Man! You are EXCEEDING your Stretch goal for the month!",IF(E41=H41,"Nice work! You are meeting your stretch goal for the month!",IF(E41=G41,"Great work. You are meeting your Target goal.",IF(E41=F41,"You are meeting Threshold. Which is the bare minimum.",IF(E41<F41,"Um... so yeah... you might want to do some work, Dude."))))) What I would like to do is assign each quote to a variable on Sheet B like such: exceed = "Rock on, Man! You are EXCEEDING your Stretch goal for the month!" stretch = "Nice work! You are meeting your stretch goal for the month!" target = "Great work. You are meeting your Target goal." threshold = "You are meeting Threshold. Which is the bare minimum." slack = "Um... so yeah... you might want to do some work, Dude." And I would like to replace the code above with something like this: =IF(E41H41,exceed,IF(E41=H41,stretch,IF(E41=G41 ,target,IF(E41=F41,threshold,IF(E41<F41,slack)))) ) What is the correct syntax to make this work? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a statement to several documents | Excel Worksheet Functions | |||
| How to protect and unprotect multiple worksheets effeciently | Excel Discussion (Misc queries) | |||
| Adding A Not(IsBlank) To IF Statement(help) | Excel Worksheet Functions | |||
| How do I effeciently share text from two different sheets? | Excel Worksheet Functions | |||
| adding if statement results | Excel Worksheet Functions | |||
Hybrid Mode
