| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting up an IF function using a name rather than a number
I want to set up formulas such as:
=IF(E7='Smith',F7,0) =IF(E7='Jones',F7,0) but it isn't working. Do I need a numerical value in the "logical test"? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Setting up an IF function using a name rather than a number
Change the single quotes to double quotes.
=IF(E7="Smith",F7,0) Gord Dibben MS Excel MVP On Thu, 19 Oct 2006 17:44:01 -0700, karenhvb wrote: I want to set up formulas such as: =IF(E7='Smith',F7,0) =IF(E7='Jones',F7,0) but it isn't working. Do I need a numerical value in the "logical test"? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Setting up an IF function using a name rather than a number
Use double quotes not single quotes.
-- Gary's Student "karenhvb" wrote: I want to set up formulas such as: =IF(E7='Smith',F7,0) =IF(E7='Jones',F7,0) but it isn't working. Do I need a numerical value in the "logical test"? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Setting up an IF function using a name rather than a number
Try this:
=IF(OR(E7={"Smith","Jones"}),F7,0) "karenhvb" wrote: I want to set up formulas such as: =IF(E7='Smith',F7,0) =IF(E7='Jones',F7,0) but it isn't working. Do I need a numerical value in the "logical test"? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
| a function that counts the number of cells with information | Excel Worksheet Functions | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Setting Cell Number Format With A Worksheet Function | Excel Worksheet Functions | |||
| Text Function with Different Formatting for Number | Excel Discussion (Misc queries) | |||
Hybrid Mode
