Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using a conditional suffix in text function format syntax=text(value,format_text) | Excel Worksheet Functions | |||
Can Text Function change output text color? | Excel Discussion (Misc queries) | |||
Advanced text function (combining text) | Excel Worksheet Functions | |||
Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) |