LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default converting text to numbers

I have columns "A", "B", and "C". I want to place an "X" in only one of the
cells in the row below. If x is in column "A", it will =4. If x is in column
"B", it will =8. If x is in column "C", it will =15. How do I create this
formula so that whatever x equals, that number will be displayed in cell F2?

Thanks in advance,

--
Have a great day!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting text to numbers [email protected] Excel Worksheet Functions 2 August 30th 07 09:22 PM
converting numbers to text gls858 New Users to Excel 2 October 18th 05 10:56 PM
Converting numbers formatted as text to numbers Bill Excel Discussion (Misc queries) 1 July 19th 05 07:10 PM
converting numbers to text and prefill text field with 0's Jan Buckley Excel Discussion (Misc queries) 2 January 20th 05 09:03 PM
Converting text to numbers Scott Excel Discussion (Misc queries) 3 November 26th 04 09:17 PM


All times are GMT +1. The time now is 06:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"