Need to display a number when a specific text is entered
 

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!

Need to display a number when a specific text is entered
 

One way:

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

--
Biff
Microsoft Excel MVP


"Desperate" wrote in message
...
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!

Need to display a number when a specific text is entered
 

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.

"T. Valko" wrote:

One way:

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

--
Biff
Microsoft Excel MVP


"Desperate" wrote in message
...
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!

Need to display a number when a specific text is entered
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Desperate" wrote in message
...
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.

"T. Valko" wrote:

One way:

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

--
Biff
Microsoft Excel MVP


"Desperate" wrote in message
...
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!