I am trying to write a formula that puts a number in cell (A) if a date cell and a text cell have certain info in them. However, if the correct info is NOT in the Date and Text cell, I want the number that is already in Cell (A) to remain untouched.
I am using this formula to pull the info over, but I don't know how to make the "value if false" keep the number in the cell.
=IF(AND(FORM!$B$2=DATE(2002,9,3),FORM!$B$3="HNL"),FORM!$B$6,??????)
Thank you!!!!!
I am using this formula to pull the info over, but I don't know how to make the "value if false" keep the number in the cell.
=IF(AND(FORM!$B$2=DATE(2002,9,3),FORM!$B$3="HNL"),FORM!$B$6,??????)
Thank you!!!!!