Cells display a total or text
Solved/Closed
Related:
- Cells display a total or text
- Total war warhammer 3 free download - Download - Strategy
- Total copy - Download - File management
- Download mp3 with lyrics display - Download - Audio playback
- To display a text file in reverse order what command should be used - Guide
- Total video converter for pc - Download - Video converters
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Nov 10, 2011 at 10:36 AM
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
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
Nov 11, 2011 at 06:05 PM