Hi everyone,
Thanks in advance for all the great help. I created the formula below and it works like it should. However I need to tweak it and don't have a clue how to do that.
=IFERROR(IF(S7="P&L Expense","Deposit Variance"&" "&RIGHT(Q7,10),"Change Order"&" "&RIGHT(Q8,10)),"")
What I need to say is this: If E7 CONTAINS "3742" then ignore everything above and the result should be "No Cash Sale". If E7 doesn't contain "3742" then do the formula above. Perhaps there's an easier way to write the formula above as well but I'm not sure.
Again thanks for all the assistance!
Thanks in advance for all the great help. I created the formula below and it works like it should. However I need to tweak it and don't have a clue how to do that.
=IFERROR(IF(S7="P&L Expense","Deposit Variance"&" "&RIGHT(Q7,10),"Change Order"&" "&RIGHT(Q8,10)),"")
What I need to say is this: If E7 CONTAINS "3742" then ignore everything above and the result should be "No Cash Sale". If E7 doesn't contain "3742" then do the formula above. Perhaps there's an easier way to write the formula above as well but I'm not sure.
Again thanks for all the assistance!