Need to display a number when a specific text is entered

D

Desperate

I have 4 different text options that I enter in column A. I need a
corresponding price to automatically display in column C. For example:
EE = 4.74
ES = 9.68
EC = 9.58
FAM = 13.78
I need to enter these same text options in 3 separate columns and have a
different price assigned.
What formula do I use? How should it be written? Please help, I've been goin
craZ with this all day!
 
T

T. Valko

One way:

=IF(A1="EE",4.74,IF(A1="ES",9.68,IF(A1="EC",9.58,IF(A1="FAM",13.78,""))))
 
D

Desperate

THANK YOU SO MUCH! It worked. I wish I would've posted this 12 hours ago
instead of struggling all day. I appreciate your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
fomulas for tracking time entered text or data 1
formula to count text entries and return text with most entries 8
display text in a cell in a range of cells 1
Trying to run excel vba code when cell value changes from empty to entered value. 1
Display text from a single cell in a column range 2
Display entire 19 digit number 2
Some Cells display text others dates in the same column 2

Top