I'd like to add a formula to my sheet where if it's blank you do nothing, but if it's not blank, i want to include text and also link to other cells.
Example: If the course number is blank, then do nothing, but if the course number isn't blank then put "Please charge invoice to" [Account Number]@row, "Org Ref" [Class Number]@row, "Class field trip in" [Event Name]@row
Hope that makes sense, i've tried this for 2 days now and i can't figure it out!
Help Article Resources
Check out the Formula Handbook template!