Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Result Formula
I'm having a problem with my formula to get Excel to print text as a result.
The formula that I am using is: =IF(C2=36,Passing,(C2<=36,Unsatisfactory)) Can someone please tell me what I am missing? I am a #NAME? message. Thank you, Bernie -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200607/1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Result Formula
=IF(C2=36,"Passing",IF(C2<=36,"Unsatisfactory"))
Try this one, you needed to add another IF and if you want text you need to put quotes around the word. "Creolekitten via OfficeKB.com" wrote: I'm having a problem with my formula to get Excel to print text as a result. The formula that I am using is: =IF(C2=36,Passing,(C2<=36,Unsatisfactory)) Can someone please tell me what I am missing? I am a #NAME? message. Thank you, Bernie -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200607/1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Result Formula
=IF(C2<=36,"Unsatisfactory","Passing")
"Creolekitten via OfficeKB.com" wrote: I'm having a problem with my formula to get Excel to print text as a result. The formula that I am using is: =IF(C2=36,Passing,(C2<=36,Unsatisfactory)) Can someone please tell me what I am missing? I am a #NAME? message. Thank you, Bernie -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200607/1 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Result Formula
Try this formula
=IF(C2=36,"Passing","Unsatisfactory") 1. You need quotes around any text you want outputted in a formula. Otherwise it looks for a range with that name. 2. You don't need to specify C2<=36, because if it is not =36 then it has to be <36. "Creolekitten via OfficeKB.com" wrote: I'm having a problem with my formula to get Excel to print text as a result. The formula that I am using is: =IF(C2=36,Passing,(C2<=36,Unsatisfactory)) Can someone please tell me what I am missing? I am a #NAME? message. Thank you, Bernie -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200607/1 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Result Formula
My bad, as shown by the other posters you do not need to add the extraneous
IF I added to the formula. My apologies. "Creolekitten via OfficeKB.com" wrote: I'm having a problem with my formula to get Excel to print text as a result. The formula that I am using is: =IF(C2=36,Passing,(C2<=36,Unsatisfactory)) Can someone please tell me what I am missing? I am a #NAME? message. Thank you, Bernie -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200607/1 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Result Formula
Hi Tim and everyone thank you for your help. I do need the second if because
the 36 won't stay the same that result is from another percentage and it will change as the other data changes. Bernie tim m wrote: My bad, as shown by the other posters you do not need to add the extraneous IF I added to the formula. My apologies. I'm having a problem with my formula to get Excel to print text as a result. The formula that I am using is: =IF(C2=36,Passing,(C2<=36,Unsatisfactory)) Can someone please tell me what I am missing? I am a #NAME? message. Thank you, Bernie -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displays the number in text. (One thousand two hundred thirty four | Excel Worksheet Functions | |||
how to use spellnumber formula | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Adding text to the result of a formula? | Excel Worksheet Functions |