Posted to microsoft.public.excel.programming

Steve[_29_] Steve[_29_] is offline

external usenet poster

Posts: 5

corrected formulas

Tom is da' man.

(he made an teensy eensy error though)

weensy even...

corrected formulas (formulae, whatever!)

=TEXT(DATE(2003,CODE(LEFT(RIGHT(A2,2),1))-64,1),"mmm")
=IF(LEFT(RIGHT(A2,2),1)<="L","Call","Put")

Steve

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
i corrected a formula, need go back to worksheet	elie harb	New Users to Excel	1	March 16th 09 10:57 PM
How do I 'SUM' a column corrected to 2 decimal places from 3	barkingmad	Excel Discussion (Misc queries)	2	May 19th 08 10:01 AM
Combining columns corrected	jezzica85	Excel Discussion (Misc queries)	2	March 11th 06 12:23 PM
IF AND question corrected	Lee	Excel Worksheet Functions	3	May 30th 05 01:12 AM
Array formula reference (Corrected)	JAK	Excel Discussion (Misc queries)	3	February 22nd 05 03:38 AM

All times are GMT +1. The time now is 12:09 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us