OK, it looks like your values are in columns B-D. This formula should account for the percentages on the end:
![]()
=IF(COUNT(C2:D2)=2,IF(D2<=1,B2&C2,B2&C2&D2),IF(COUNT(C2:D2)=1,IF(C2<=1,B2,B2&C2),B2))
OK, it looks like your values are in columns B-D. This formula should account for the percentages on the end:
![]()
=IF(COUNT(C2:D2)=2,IF(D2<=1,B2&C2,B2&C2&D2),IF(COUNT(C2:D2)=1,IF(C2<=1,B2,B2&C2),B2))
If I have helped, please click the star below.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks