| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up an "IF" formula?
I WANT CELL D TO SAY A CERTAIN TRUCK# "IF" CELL C IS A CERTAIN DRIVER NAME.
ie: "IF" C8 SAYS "CHRIS", D9 SAYS 506 I keep getting errors. What am I doing wrong? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I set up an "IF" formula?
On Wed, 16 Nov 2005 05:40:51 -0800, Lady@scalehouse
wrote: I WANT CELL D TO SAY A CERTAIN TRUCK# "IF" CELL C IS A CERTAIN DRIVER NAME. ie: "IF" C8 SAYS "CHRIS", D9 SAYS 506 I keep getting errors. What am I doing wrong? There is a problem either with your syntax or your data. --ron |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I set up an "IF" formula?
You should try the Vlookup function for what you want to do
|
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I set up an "IF" formula?
In D9 put formula:
=IF(C8="CHRIS", 506, "") "Lady@scalehouse" wrote in message ... I WANT CELL D TO SAY A CERTAIN TRUCK# "IF" CELL C IS A CERTAIN DRIVER NAME. ie: "IF" C8 SAYS "CHRIS", D9 SAYS 506 I keep getting errors. What am I doing wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula? | Excel Worksheet Functions | |||
| writing a formula for a colored value | New Users to Excel | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
