| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
does an IF function only look up numbers & not text?
I am trying to calculate a forumula to show -- IF "yes" display 2, IF "no"
display 0. I'm loosing my marbles over this simple function. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
does an IF function only look up numbers & not text?
try
if(A5="yes",2,0) or if(A5="yes",2,if(A5="no",0,"")) if you want text (2 or 0) to be displayed, put " (double quotes) around the numbers. good luck! "CAPGirl" wrote: I am trying to calculate a forumula to show -- IF "yes" display 2, IF "no" display 0. I'm loosing my marbles over this simple function. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
does an IF function only look up numbers & not text?
Patrick - thank you! I needed the double quotations!! Lifer for me today!!
Enjoy the remainder of your day! Cheers! "Patrick" wrote: try if(A5="yes",2,0) or if(A5="yes",2,if(A5="no",0,"")) if you want text (2 or 0) to be displayed, put " (double quotes) around the numbers. good luck! "CAPGirl" wrote: I am trying to calculate a forumula to show -- IF "yes" display 2, IF "no" display 0. I'm loosing my marbles over this simple function. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
| Using numbers as numbers in a cell having text | Excel Discussion (Misc queries) | |||
| Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
| How do I set up an IF function with text and numbers? | Excel Worksheet Functions | |||
Hybrid Mode
