View Single Post
  #5   Report Post  
David
 
Posts: n/a
Default

?B?R2FyeScncyBTdHVkZW50?= wrote

You can combine the cells into a single cell solution
if this is what you need.


Given what we have in place, that would be one long formula, would it not?
And I wouldn't know how.

I use another formula to display the result, anyway:
="**Deliver "&TEXT(G89,"dddd, mmm d")&" Please**"
where G89 now contains the former D1 CHOOSE() formula

I will live with the 4-cell variety since it doesn't interfere with the
look and feel of my sheet. I've made the fontcolor of those cells white so
a viewer won't see them.

--
David