I have a coalesce UDF I use all the time but sometimes I forget to convert to values. Anyone have a formula that will do the same thing so if I leave it as a formula it will not break when I send to outside my Excel app?
P.S. in case someone doesn't know coalesce is usually a sql function that...