I am using the following formula:
I need to be able to also check another cell for a date value, AO10. If there is a value there it returns the value, adds a space, and then (A). If there isnt a value, it just goes through the original formula.
Ideally, it would look like this with both having values:
Value in I10 and no value AO10:
Value in AO10 and no value in I10: