Cell a1 is a formula that looks at another cell and returns a date or ""
(nothing)
Cell a2 is a formula that looks at another cell and returns a number or ""
(nothing)
Now I need a formula that looks at a1 and if the result equals "" then
return a2 otherwise return a1.
Any help will be appreciated.
Bookmarks