I am converting some old Lotus123 files to Excel.
I have three columns Sequence, Month, Cost. I wish to recover the Cost number in a fourth column.
The "Month" column formula in Lotus is: +MONTH="Jan"#OR#MONTH="Feb"#OR#MONTH="March"#OR#MONTH="Apr"#OR#MONTH="May"#OR#MONTH="June"#OR#MONTH="July"#OR#MONTH="Aug"#OR#MONTH="Sept"#OR#MONTH="Oct"#OR#MONTH="Nov"#OR#MONTH="Dec"
How do I get to the Excel equivalent to this formula?
Thanks for your help.
Bookmarks