using text in an if function
 

I am trying to make a formula that will take the value in one cell and place
a value in another cell. ex a1=shop then a2 would = 85 but if a1 = on site
then a2 would = 95. When I try this I get a #name? error.
Can any one help this beginner?

using text in an if function
 

In A2 try:
=IF(A1="shop",85,IF(A1="on site",95,""))

Hope this helps
Rowan

Brent wrote:
I am trying to make a formula that will take the value in one cell and place
a value in another cell. ex a1=shop then a2 would = 85 but if a1 = on site
then a2 would = 95. When I try this I get a #name? error.
Can any one help this beginner?

using text in an if function
 

Brent,

if you're just trying to type this formula into a cell, then the text values
have to be inside inverted commas, otherwise Excel assumes you're referring
to a named range.

=IF(A1="shop",85,0)

Cheers, Pete.


"Brent" wrote:

I am trying to make a formula that will take the value in one cell and place
a value in another cell. ex a1=shop then a2 would = 85 but if a1 = on site
then a2 would = 95. When I try this I get a #name? error.
Can any one help this beginner?

using text in an if function
 

=(A1="shop")*85+(A1="site")*95

You are getting an error probably because you need the double quotes.
--
Gary''s Student


"Brent" wrote:

I am trying to make a formula that will take the value in one cell and place
a value in another cell. ex a1=shop then a2 would = 85 but if a1 = on site
then a2 would = 95. When I try this I get a #name? error.
Can any one help this beginner?

using text in an if function
 

in a2 put this formula:
=IF(A1="shop",85,IF(A1="on site",95,""))
"Brent" wrote:

I am trying to make a formula that will take the value in one cell and place
a value in another cell. ex a1=shop then a2 would = 85 but if a1 = on site
then a2 would = 95. When I try this I get a #name? error.
Can any one help this beginner?