Share via

excel 2010 IF in a cell defined as date. IF the test is false I want the cell to be unchanged

Brian Mazakas 1 Reputation point
2021-11-05T01:05:36.063+00:00

The sheet is new each month in a 12 month workbook. IF is in B1, IF a dollar amount is in cell A1 and Cell C1 is blank, put the TODAY() in B1. What's happening is if either test is false the date
is changed to 0/0/0. I want the date or blank in B1 cell to be left alone. IF (A1>0,IF (C1<=" ",TODAY(),),) any body?

Microsoft 365 and Office | Development | Other
0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.