Convert RGB to CMYK in single line of code.
I hate looking at sloppy code, and writing it makes me giggle, but I must provide this, because I used your code to make mine. Stood on the shoulders of giants so to speak.
This first code will convert RGB in (R,G,B) format into C #% M#% Y#% K#%
Example:
In cell A1 enter (100,28,22)
In cell B1 enter
="C "&ROUND((1-(1-MAX(MID(A1|2|FIND(","|A1)-2)/255|MID(A1|FIND(","|A1)+1|FIND(","|A1|FIND(","|A1)+1)-FIND(","|A1)-1)/255|MID(A1|FIND(","|A1|FIND(","|A1)+1)+1|FIND(")"|A1)-FIND(","|A1|FIND(","|A1)+1)-1)/255))-MID(A1|2|FIND(","|A1)-2)/255)/(1-(1-MAX(MID(A1|2|FIND(","|A1)-2)/255|MID(A1|FIND(","|A1)+1|FIND(","|A1|FIND(","|A1)+1)-FIND(","|A1)-1)/255|MID(A1|FIND(","|A1|FIND(","|A1)+1)+1|FIND(")"|A1)-FIND(","|A1|FIND(","|A1)+1)-1)/255)))*100|0)&"% M "&ROUND((1-(1-MAX(MID(A1|2|FIND(","|A1)-2)/255|MID(A1|FIND(","|A1)+1|FIND(","|A1|FIND(","|A1)+1)-FIND(","|A1)-1)/255|MID(A1|FIND(","|A1|FIND(","|A1)+1)+1|FIND(")"|A1)-FIND(","|A1|FIND(","|A1)+1)-1)/255))-MID(A1|FIND(","|A1)+1|FIND(","|A1|FIND(","|A1)+1)-FIND(","|A1)-1)/255)/(1-(1-MAX(MID(A1|2|FIND(","|A1)-2)/255|MID(A1|FIND(","|A1)+1|FIND(","|A1|FIND(","|A1)+1)-FIND(","|A1)-1)/255|MID(A1|FIND(","|A1|FIND(","|A1)+1)+1|FIND(")"|A1)-FIND(","|A1|FIND(","|A1)+1)-1)/255)))*100|0)&"% Y "&ROUND(((1-(1-MAX(MID(A1|2|FIND(","|A1)-2)/255|MID(A1|FIND(","|A1)+1|FIND(","|A1|FIND(","|A1)+1)-FIND(","|A1)-1)/255|MID(A1|FIND(","|A1|FIND(","|A1)+1)+1|FIND(")"|A1)-FIND(","|A1|FIND(","|A1)+1)-1)/255))-MID(A1|FIND(","|A1|FIND(","|A1)+1)+1|FIND(")"|A1)-FIND(","|A1|FIND(","|A1)+1)-1)/255)/(1-(1-MAX(MID(A1|2|FIND(","|A1)-2)/255|MID(A1|FIND(","|A1)+1|FIND(","|A1|FIND(","|A1)+1)-FIND(","|A1)-1)/255|MID(A1|FIND(","|A1|FIND(","|A1)+1)+1|FIND(")"|A1)-FIND(","|A1|FIND(","|A1)+1)-1)/255))))*100|0)&"% K "&ROUND((1-MAX(MID(A1|2|FIND(","|A1)-2)/255|MID(A1|FIND(","|A1)+1|FIND(","|A1|FIND(","|A1)+1)-FIND(","|A1)-1)/255|MID(A1|FIND(","|A1|FIND(","|A1)+1)+1|FIND(")"|A1)-FIND(","|A1|FIND(","|A1)+1)-1)/255))*100|0)
Cell B2 shows C 0% M 72% Y 78% K 61
Or, alternately, if you were looking for a CMYK color simply enclosed in parentheses (C,M,Y,K), like the RGB color
Use this code in B1:
="("&ROUND((1-(1-MAX(MID(A2|2|FIND(","|A2)-2)/255|MID(A2|FIND(","|A2)+1|FIND(","|A2|FIND(","|A2)+1)-FIND(","|A2)-1)/255|MID(A2|FIND(","|A2|FIND(","|A2)+1)+1|FIND(")"|A2)-FIND(","|A2|FIND(","|A2)+1)-1)/255))-MID(A2|2|FIND(","|A2)-2)/255)/(1-(1-MAX(MID(A2|2|FIND(","|A2)-2)/255|MID(A2|FIND(","|A2)+1|FIND(","|A2|FIND(","|A2)+1)-FIND(","|A2)-1)/255|MID(A2|FIND(","|A2|FIND(","|A2)+1)+1|FIND(")"|A2)-FIND(","|A2|FIND(","|A2)+1)-1)/255)))*100|0)&","&ROUND((1-(1-MAX(MID(A2|2|FIND(","|A2)-2)/255|MID(A2|FIND(","|A2)+1|FIND(","|A2|FIND(","|A2)+1)-FIND(","|A2)-1)/255|MID(A2|FIND(","|A2|FIND(","|A2)+1)+1|FIND(")"|A2)-FIND(","|A2|FIND(","|A2)+1)-1)/255))-MID(A2|FIND(","|A2)+1|FIND(","|A2|FIND(","|A2)+1)-FIND(","|A2)-1)/255)/(1-(1-MAX(MID(A2|2|FIND(","|A2)-2)/255|MID(A2|FIND(","|A2)+1|FIND(","|A2|FIND(","|A2)+1)-FIND(","|A2)-1)/255|MID(A2|FIND(","|A2|FIND(","|A2)+1)+1|FIND(")"|A2)-FIND(","|A2|FIND(","|A2)+1)-1)/255)))*100|0)&","&ROUND(((1-(1-MAX(MID(A2|2|FIND(","|A2)-2)/255|MID(A2|FIND(","|A2)+1|FIND(","|A2|FIND(","|A2)+1)-FIND(","|A2)-1)/255|MID(A2|FIND(","|A2|FIND(","|A2)+1)+1|FIND(")"|A2)-FIND(","|A2|FIND(","|A2)+1)-1)/255))-MID(A2|FIND(","|A2|FIND(","|A2)+1)+1|FIND(")"|A2)-FIND(","|A2|FIND(","|A2)+1)-1)/255)/(1-(1-MAX(MID(A2|2|FIND(","|A2)-2)/255|MID(A2|FIND(","|A2)+1|FIND(","|A2|FIND(","|A2)+1)-FIND(","|A2)-1)/255|MID(A2|FIND(","|A2|FIND(","|A2)+1)+1|FIND(")"|A2)-FIND(","|A2|FIND(","|A2)+1)-1)/255))))*100|0)&","&ROUND((1-MAX(MID(A2|2|FIND(","|A2)-2)/255|MID(A2|FIND(","|A2)+1|FIND(","|A2|FIND(","|A2)+1)-FIND(","|A2)-1)/255|MID(A2|FIND(","|A2|FIND(","|A2)+1)+1|FIND(")"|A2)-FIND(","|A2|FIND(","|A2)+1)-1)/255))*100|0)&")"
Cell B2 shows (0,72,78,61)
BULK
Put a list of RGB colors in the A column in (R,G,B) format.
Select either of the formulas for B1.
Select cell B1
Use the fill handle to fill the formula from B1 down parallel with the last RGB value.
Conversion complete.