IF Function
 

I am trying to determine whether or not a sales amount is "In-State" or "Out
of State" for sales tax purposes. Spreadsheet example is below.

The formula I wrote for Column E is: =IF(a1=IL,d1,0)
The formula for Column F is: =IF(a1=IL,0,d1).
The return I get for each cell is #Name?. I have formatted the cells in
column a as text and the cells in columns D, E & F as numbers. The assistant
tells me that cell a1 (et al) is an invalid name. What gives? Can someone
please help? Thanks in advance.

A B C D E F

State Qty Desc Cost In-State Out-State

1 AL 1 Item 2 89.99
2 IL 1 Item 2 89.99

IF Function
 

Without looking at he rest of the problem, it look like you just need some
quotes
=IF(a1="IL",0,d1).

Without "IL", Excel is looking for a cell named IL
Textual arguments must always be in quotes.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Jules" wrote in message
...
I am trying to determine whether or not a sales amount is "In-State" or
"Out
of State" for sales tax purposes. Spreadsheet example is below.

The formula I wrote for Column E is: =IF(a1=IL,d1,0)
The formula for Column F is: =IF(a1=IL,0,d1).
The return I get for each cell is #Name?. I have formatted the cells in
column a as text and the cells in columns D, E & F as numbers. The
assistant
tells me that cell a1 (et al) is an invalid name. What gives? Can
someone
please help? Thanks in advance.

A B C D E F

State Qty Desc Cost In-State Out-State

1 AL 1 Item 2 89.99
2 IL 1 Item 2 89.99

IF Function
 

Put double quotes around IL and it will work:

=IF(a1="IL",d1,0)


--
Biff
Microsoft Excel MVP


"Jules" wrote in message
...
I am trying to determine whether or not a sales amount is "In-State" or
"Out
of State" for sales tax purposes. Spreadsheet example is below.

The formula I wrote for Column E is: =IF(a1=IL,d1,0)
The formula for Column F is: =IF(a1=IL,0,d1).
The return I get for each cell is #Name?. I have formatted the cells in
column a as text and the cells in columns D, E & F as numbers. The
assistant
tells me that cell a1 (et al) is an invalid name. What gives? Can
someone
please help? Thanks in advance.

A B C D E F

State Qty Desc Cost In-State Out-State

1 AL 1 Item 2 89.99
2 IL 1 Item 2 89.99

IF Function
 

Thank you both for your response....You were exactly right. Thanks again!

"Jules" wrote:

I am trying to determine whether or not a sales amount is "In-State" or "Out
of State" for sales tax purposes. Spreadsheet example is below.

The formula I wrote for Column E is: =IF(a1=IL,d1,0)
The formula for Column F is: =IF(a1=IL,0,d1).
The return I get for each cell is #Name?. I have formatted the cells in
column a as text and the cells in columns D, E & F as numbers. The assistant
tells me that cell a1 (et al) is an invalid name. What gives? Can someone
please help? Thanks in advance.

A B C D E F

State Qty Desc Cost In-State Out-State

1 AL 1 Item 2 89.99
2 IL 1 Item 2 89.99

IF Function
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Jules" wrote in message
...
Thank you both for your response....You were exactly right. Thanks again!

"Jules" wrote:

I am trying to determine whether or not a sales amount is "In-State" or
"Out
of State" for sales tax purposes. Spreadsheet example is below.

The formula I wrote for Column E is: =IF(a1=IL,d1,0)
The formula for Column F is: =IF(a1=IL,0,d1).
The return I get for each cell is #Name?. I have formatted the cells in
column a as text and the cells in columns D, E & F as numbers. The
assistant
tells me that cell a1 (et al) is an invalid name. What gives? Can
someone
please help? Thanks in advance.

A B C D E F

State Qty Desc Cost In-State Out-State

1 AL 1 Item 2 89.99
2 IL 1 Item 2 89.99