Cells display a total or text

Solved/Closed
Michael - Nov 6, 2011 at 03:22 PM
 Michael - Nov 11, 2011 at 06:05 PM
Hello,

I have an excel workbook that has cells that display a currency amount U43, U45, U47, U49, U51 and Q53. For example U43 would have $200 in it, then U45 would have $500, and so on. I have T53 with this code in it =SUM($U$43,$U$45,$U$47,$U$49,$U$51,$Q$53) to total the amounts into one box. But if the box displays a text, I want T53 to display the text in the cells. For example if U43 equals $200, U45 equals $500 and U47 equals "No Bond" then I want T53 to display the text "No Bond" instead of calulating the total. I would like it that if any of the cells display the text then Q53 displays the text as well no matter what box has the text.

Thank you.

Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Nov 10, 2011 at 10:36 AM
Hi Michael,

Try this formula in T53:
=IF(T(U43)="",IF(T(U45)="",IF(T(U47)="",IF(T(U49)="",IF(T(U51)="",IF(T(Q53)="",SUM(U43,U45,U47,U49,U51,Q53),Q53),U51),U49),U47),U45),U43)


Best regards,
Trowa
1
This worked perfectly. Thanks.
0