ExcelBanter - How do I set up an "IF" formula?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I set up an "IF" formula? (https://www.excelbanter.com/excel-worksheet-functions/55730-how-do-i-set-up-if-formula.html)

Lady@scalehouse

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?

Ron Rosenfeld

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

tiah

How do I set up an "IF" formula?

You should try the Vlookup function for what you want to do

Mladen_Dj

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?

All times are GMT +1. The time now is 03:08 PM.