Logic Statements

[Chris Sear]

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

 

[Bernard Liengme]

=IF(A1="Y",-3,"whatever you desire")
best wishes

 

[M Kan]

Or, if you have more codes you want to match up, use a VLOOKUP table.