May be:![]()
=IF(COUNTIF(B3:B6,"")=0,"$"&MIN(B3:B6)&"-$"&MAX(B3:B6)&",","")&TEXT(MIN(C3:C6)*100,"0.0")&"%-"&TEXT(MAX(C3:C6)*100,"0.0")&"%"
May be:![]()
=IF(COUNTIF(B3:B6,"")=0,"$"&MIN(B3:B6)&"-$"&MAX(B3:B6)&",","")&TEXT(MIN(C3:C6)*100,"0.0")&"%-"&TEXT(MAX(C3:C6)*100,"0.0")&"%"
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks