Creating a history with IF function

[Phatboy_D]

I have a spreadsheet that reports daily manpower attendance. One sheet
currently updates other attached sheets to report different requirements
(camp, trade, etc). Currently we have to manually updated a history page
that shows attendance by date. I don't know if it's possible but I'd like to
be able to use the IF function but if the requirements of the function aren't
met I'd like it to do nothing to existing cells.

=IF((BB$2=$A$1),CONCATENATE($H3),"")

Basically A1 is the function TODAY () and the sheet compares a horizontal
daily calendar (obviously limited to 265 or so days/columns). IF todays date
matches the column calendar date I'd like manually (F9) and copy the column
information that applied to that days date.

The only issue is that the FALSE portion of the IF statement is that it
changes previous date cells. Is there a way to instead of the "", have the
IF statement do nothing?

Regards,
Dan

 

[Bob Greenblatt]

I have a spreadsheet that reports daily manpower attendance. One sheet
currently updates other attached sheets to report different requirements
(camp, trade, etc). Currently we have to manually updated a history page
that shows attendance by date. I don't know if it's possible but I'd like to
be able to use the IF function but if the requirements of the function aren't
met I'd like it to do nothing to existing cells.

=IF((BB$2=$A$1),CONCATENATE($H3),"")

Basically A1 is the function TODAY () and the sheet compares a horizontal
daily calendar (obviously limited to 265 or so days/columns). IF todays date
matches the column calendar date I'd like manually (F9) and copy the column
information that applied to that days date.

The only issue is that the FALSE portion of the IF statement is that it
changes previous date cells. Is there a way to instead of the "", have the
IF statement do nothing?

Regards,
Dan

No, there is no way for the if statement to do nothing. However, you can
duplicate the formula for the original state in the false section of the if
statement.