ExcelBanter - Logic Statements

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Logic Statements (https://www.excelbanter.com/excel-discussion-misc-queries/195639-logic-statements.html)

Logic Statements

I need a formula for a cell that gives me a numeric character (-3) return
based on another cell's alpha character (Y)

I am using windows vista, microsoft professional excel 08 O believe.

Thanks

Logic Statements

Or, if you have more codes you want to match up, use a VLOOKUP table.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips

"Bernard Liengme" wrote:

=IF(A1="Y",-3,"whatever you desire")
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Chris Sear" <Chris wrote in message
...
I need a formula for a cell that gives me a numeric character (-3) return
based on another cell's alpha character (Y)

I am using windows vista, microsoft professional excel 08 O believe.

Thanks