ExcelBanter - corrected formulas

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - corrected formulas (https://www.excelbanter.com/excel-programming/274246-corrected-formulas.html)

Steve[_29_]

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

All times are GMT +1. The time now is 07:31 AM.