ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   If Formulas with Text instead of numbers (https://www.excelbanter.com/excel-discussion-misc-queries/120601-if-formulas-text-instead-numbers.html)

RichU

If Formulas with Text instead of numbers
 
I need to a formular to do the following:

For example is Cell A1 = "a" then I want column A2 to show the date of when
that was inputted. I would have thought I would have had to put the
following:

=IF(A1=a,"=today()")

Although that doesn't seem to be the case...

Any help would be greatly appreciated.

Cheers,


All times are GMT +1. The time now is 06:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com