Hello,
Need help with 1 formula:
=TEXTJOIN({" D";" AP";" F";" R";" "};TRUE;Y10;TEXT(AB10;"0,0");AC10;AN10;TEXTJOIN({" R"};TRUE;IF(AD10>0;AD10;""););TEXTJOIN({""};TRUE;AO10;))
1. Collom Y10 will bring the first value
2. Collum AB will bring the value with 0,0 value And will ad D before the value
3. Collum AC will bring the value and ad before AP the value
4. Collum AN will bring the value and ad before F the value
FROM Here i need help- i am stuck
5.And now i have problem , i would like to and only value if the value is bigger than AD>0 and if its bigger only then AD R before the value. IF the value is smaller then nothing will happen "" and there will not be any R value before.
6. And last if there is any value we will ad also A010 without adding anything else.
Can somebody help please?
Bookmarks