On the tab labeled AR Detail, I need to pull 1 of 2 cells into column S ( PO reference).
If there is a number in column M (Account Code 1)then use that number, however if is blank then use the data that is in column L (PO#).
I tried this formula but it didn't work .
=IF(M4>1,M4,IF(M4<1,L4))
I also need to add a trim function to it.
=TRIM(LEFT(M4,10))
Solved by K. L. in 15 mins