Hi guys,

I am stuck on a simple IF function pls help.

=IF(A2="",A1,A2) - when the logical test = true it's giving me a blank cell (instead of giving me the value of A1). However when the logical test = false, there seems to be no problem (it does give me the value of A2).

can anybody pls help, or suggest a better formula if possible.

Thanks