I am trying to put the results of 3 cells into one cell. Here's what I
am trying to do: e7 will equal either "" or 30, f7 will equal either""
or 36 and g7 will equal "" or 48. When any one of the cells has the
appropiate number in it, 30, 36, or 48 the other two cells will be
"".How do I write a formula for one cell that will have the result of
30, 36, or 48 in it based on the cells e7,f7 or g7?
Thank you,