Google Sheets Character Playground

Progress bars, star ratings, emoji scenes, and more.

Block progress bar

=REPT("โ–ˆ",A1)&REPT("โ–‘",10-A1)

โ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–‘โ–‘

REPT

Star rating (5 stars)

=REPT("โ˜…",A1)&REPT("โ˜†",5-A1)

โ˜…โ˜…โ˜…โ˜†โ˜†

REPT

3 of 5 with White Star

=REPT(CHAR(9734),A1)&REPT(CHAR(9885),5-A1)

โ˜†โ˜†โ˜†โšโš

REPT CHAR

Star rating with Outlined White Star

=REPT(CHAR(9885),A1)&REPT(CHAR(9734),5-A1)

โšโšโšโ˜†โ˜†

REPT CHAR

3 of 5 with Black Four Pointed Star

=REPT(CHAR(10022),A1)&REPT(CHAR(10023),5-A1)

โœฆโœฆโœฆโœงโœง

REPT CHAR

Star rating with White Four Pointed Star

=REPT(CHAR(10023),A1)&REPT(CHAR(10022),5-A1)

โœงโœงโœงโœฆโœฆ

REPT CHAR

Star rating with Stress Outlined White Star

=REPT(CHAR(10025),A1)&REPT(CHAR(9885),5-A1)

โœฉโœฉโœฉโšโš

REPT CHAR

3 of 5 with Circled White Star

=REPT(CHAR(10026),A1)&REPT(CHAR(10023),5-A1)

โœชโœชโœชโœงโœง

REPT CHAR

Star rating with Open Centre Black Star

=REPT(CHAR(10027),A1)&REPT(CHAR(10028),5-A1)

โœซโœซโœซโœฌโœฌ

REPT CHAR

3 of 5 with Black Centre White Star

=REPT(CHAR(10028),A1)&REPT(CHAR(10027),5-A1)

โœฌโœฌโœฌโœซโœซ

REPT CHAR

Star rating with Outlined Black Star

=REPT(CHAR(10029),A1)&REPT(CHAR(9885),5-A1)

โœญโœญโœญโšโš

REPT CHAR

3 of 5 with Heavy Outlined Black Star

=REPT(CHAR(10030),A1)&REPT(CHAR(10025),5-A1)

โœฎโœฎโœฎโœฉโœฉ

REPT CHAR

Star rating with Pinwheel Star

=REPT(CHAR(10031),A1)&REPT(CHAR(10037),5-A1)

โœฏโœฏโœฏโœตโœต

REPT CHAR

3 of 5 with Shadowed White Star

=REPT(CHAR(10032),A1)&REPT(CHAR(9734),5-A1)

โœฐโœฐโœฐโ˜†โ˜†

REPT CHAR

Star rating with Eight Pointed Black Star

=REPT(CHAR(10036),A1)&REPT(CHAR(10037),5-A1)

โœดโœดโœดโœตโœต

REPT CHAR

3 of 5 with Eight Pointed Pinwheel Star

=REPT(CHAR(10037),A1)&REPT(CHAR(10036),5-A1)

โœตโœตโœตโœดโœด

REPT CHAR

Star rating with Six Pointed Black Star

=REPT(CHAR(10038),A1)&REPT(CHAR(10039),5-A1)

โœถโœถโœถโœทโœท

REPT CHAR

3 of 5 with Eight Pointed Rectilinear Black Star

=REPT(CHAR(10039),A1)&REPT(CHAR(10040),5-A1)

โœทโœทโœทโœธโœธ

REPT CHAR

Star rating with Heavy Eight Pointed Rectilinear Black Star

=REPT(CHAR(10040),A1)&REPT(CHAR(10039),5-A1)

โœธโœธโœธโœทโœท

REPT CHAR

3 of 5 with Twelve Pointed Black Star

=REPT(CHAR(10041),A1)&REPT(CHAR(9734),5-A1)

โœนโœนโœนโ˜†โ˜†

REPT CHAR

Star rating with Circled Open Centre Eight Pointed Star

=REPT(CHAR(10050),A1)&REPT(CHAR(10036),5-A1)

โ‚โ‚โ‚โœดโœด

REPT CHAR

3 of 5 with White Medium Star

=REPT(CHAR(11088),A1)&REPT(CHAR(9734),5-A1)

โญโญโญโ˜†โ˜†

REPT CHAR

Star rating with Glowing Star

=REPT(UNICHAR(127775),A1)&REPT(CHAR(11088),5-A1)

๐ŸŒŸ๐ŸŒŸ๐ŸŒŸโญโญ

REPT CHAR UNICHAR

Light block progress

=REPT("โ–“",A1)&REPT("โ–‘",10-A1)

โ–“โ–“โ–“โ–“โ–“โ–“โ–“โ–“โ–‘โ–‘

REPT

Car trip to mountain

="๐Ÿ”๏ธ"&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿš—"&REPT("ใƒป",MAX(0,A1-2))

๐Ÿ”๏ธใƒปใƒปใƒปใƒปใƒปใƒป๐Ÿš—ใƒปใƒป

REPT MAX

Take Ring to Mordor

=๐Ÿ”๏ธ&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ’"&REPT("ใƒป",MAX(0,A1-2))&"๐Ÿ "

๐Ÿ”๏ธใƒปใƒปใƒปใƒปใƒป๐Ÿ’ใƒปใƒปใƒป๐Ÿ 

REPT MAX

Car trip to McDonald's

="๐ŸŸ"&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿš—"&REPT("ใƒป",MAX(0,A1-2))

๐ŸŸใƒปใƒปใƒปใƒปใƒปใƒป๐Ÿš—ใƒปใƒป

REPT MAX

Burger run by car

="๐Ÿ”"&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿš—"&REPT("ใƒป",MAX(0,A1-2))

๐Ÿ”ใƒปใƒปใƒปใƒปใƒปใƒป๐Ÿš—ใƒปใƒป

REPT MAX

Soda run to drink break

="โ˜•"&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿฅค"&REPT("ใƒป",MAX(0,A1-2))

โ˜•ใƒปใƒปใƒปใƒปใƒปใƒป๐Ÿฅคใƒปใƒป

REPT MAX

Snack run to snack break

="๐Ÿฟ"&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿช"&REPT("ใƒป",MAX(0,A1-2))

๐Ÿฟใƒปใƒปใƒปใƒปใƒปใƒป๐Ÿชใƒปใƒป

REPT MAX

Traffic light status

=IF(A1="red","๐Ÿ”ด",IF(A1="yellow","๐ŸŸก","๐ŸŸข"))

๐ŸŸข

IF

Yes / No status lights

=IF(LOWER(A1)="yes","๐ŸŸข",IF(LOWER(A1)="no","๐Ÿ”ด","๐ŸŸก"))

๐ŸŸข

IF LOWER

Approved / Not Approved thumbs

=IF(LOWER(A1)="approved","๐Ÿ‘",IF(LOWER(A1)="not approved","๐Ÿ‘Ž","๐Ÿคท"))

๐Ÿ‘

IF LOWER

Pass / Fail status lights

=IF(LOWER(A1)="pass","๐ŸŸข",IF(LOWER(A1)="fail","๐Ÿ”ด","๐ŸŸก"))

๐ŸŸข

IF LOWER

True / False status lights

=IF(LOWER(A1)="true","๐ŸŸข",IF(LOWER(A1)="false","๐Ÿ”ด","๐ŸŸก"))

๐ŸŸข

IF LOWER

On / Off status lights

=IF(LOWER(A1)="on","๐ŸŸข",IF(LOWER(A1)="off","๐Ÿ”ด","๐ŸŸก"))

๐ŸŸข

IF LOWER

Go / Stop status lights

=IF(LOWER(A1)="go","๐ŸŸข",IF(LOWER(A1)="stop","๐Ÿ”ด","๐ŸŸก"))

๐ŸŸข

IF LOWER

Active / Inactive status lights

=IF(LOWER(A1)="active","๐ŸŸข",IF(LOWER(A1)="inactive","๐Ÿ”ด","๐ŸŸก"))

๐ŸŸข

IF LOWER

Done / Pending status lights

=IF(LOWER(A1)="done","๐ŸŸข",IF(LOWER(A1)="pending","๐ŸŸก","๐Ÿ”ด"))

๐ŸŸข

IF LOWER

Paid / Unpaid status lights

=IF(LOWER(A1)="paid","๐ŸŸข",IF(LOWER(A1)="unpaid","๐Ÿ”ด","๐ŸŸก"))

๐ŸŸข

IF LOWER

In stock / Out of stock lights

=IF(LOWER(A1)="in stock","๐ŸŸข",IF(LOWER(A1)="out of stock","๐Ÿ”ด","๐ŸŸก"))

๐ŸŸข

IF LOWER

Complete / Incomplete status lights

=IF(LOWER(A1)="complete","๐ŸŸข",IF(LOWER(A1)="incomplete","๐Ÿ”ด","๐ŸŸก"))

๐ŸŸข

IF LOWER

Open / Closed status lights

=IF(LOWER(A1)="open","๐ŸŸข",IF(LOWER(A1)="closed","๐Ÿ”ด","๐ŸŸก"))

๐ŸŸข

IF LOWER

Yes / No thumbs

=IF(LOWER(A1)="yes","๐Ÿ‘",IF(LOWER(A1)="no","๐Ÿ‘Ž","๐Ÿคท"))

๐Ÿ‘

IF LOWER

Pass / Fail celebration

=IF(LOWER(A1)="pass","๐ŸŽ‰",IF(LOWER(A1)="fail","๐Ÿ˜ฌ","๐Ÿค”"))

๐ŸŽ‰

IF LOWER

Go / Stop road signs

=IF(LOWER(A1)="go","๐Ÿ",IF(LOWER(A1)="stop","๐Ÿ›‘","โธ๏ธ"))

๐Ÿ

IF LOWER

Active / Inactive energy

=IF(LOWER(A1)="active","โšก",IF(LOWER(A1)="inactive","๐Ÿ’ค","๐Ÿ˜ด"))

โšก

IF LOWER

Done / Pending clocks

=IF(LOWER(A1)="done","โœ…",IF(LOWER(A1)="pending","โณ","โŒ›"))

โœ…

IF LOWER

Paid / Unpaid money

=IF(LOWER(A1)="paid","๐Ÿ’ฐ",IF(LOWER(A1)="unpaid","๐Ÿ’ธ","โ“"))

๐Ÿ’ฐ

IF LOWER

In stock / Out of stock boxes

=IF(LOWER(A1)="in stock","๐Ÿ“ฆ",IF(LOWER(A1)="out of stock","๐Ÿ“ญ","๐Ÿคท"))

๐Ÿ“ฆ

IF LOWER

Complete / Incomplete puzzle

=IF(LOWER(A1)="complete","๐Ÿงฉ",IF(LOWER(A1)="incomplete","๐Ÿšง","๐Ÿ”"))

๐Ÿงฉ

IF LOWER

Open / Closed locks

=IF(LOWER(A1)="open","๐Ÿ”“",IF(LOWER(A1)="closed","๐Ÿ”’","๐Ÿ”‘"))

๐Ÿ”“

IF LOWER

True / False marks

=IF(LOWER(A1)="true","โœ…",IF(LOWER(A1)="false","โŒ","โ”"))

โœ…

IF LOWER

On / Off power

=IF(LOWER(A1)="on","๐Ÿ’ก",IF(LOWER(A1)="off","๐ŸŒ™","๐Ÿ”Œ"))

๐Ÿ’ก

IF LOWER

Win / Lose trophies

=IF(LOWER(A1)="win","๐Ÿ†",IF(LOWER(A1)="lose","๐Ÿ˜ข","๐Ÿค"))

๐Ÿ†

IF LOWER

Accept / Decline hands

=IF(LOWER(A1)="accept","๐Ÿ™Œ",IF(LOWER(A1)="decline","๐Ÿ™…","๐Ÿคท"))

๐Ÿ™Œ

IF LOWER

Safe / Danger shields

=IF(LOWER(A1)="safe","๐Ÿ›ก๏ธ",IF(LOWER(A1)="danger","โš ๏ธ","โ˜ ๏ธ"))

๐Ÿ›ก๏ธ

IF LOWER

Online / Offline signal

=IF(LOWER(A1)="online","๐Ÿ“ถ",IF(LOWER(A1)="offline","๐Ÿ“ต","๐Ÿ”„"))

๐Ÿ“ถ

IF LOWER

Like / Dislike hearts

=IF(LOWER(A1)="like","โค๏ธ",IF(LOWER(A1)="dislike","๐Ÿ’”","๐Ÿ˜"))

โค๏ธ

IF LOWER

Ship / Hold delivery

=IF(LOWER(A1)="ship","๐Ÿš€",IF(LOWER(A1)="hold","โธ๏ธ","๐Ÿ”"))

๐Ÿš€

IF LOWER

Success / Error bursts

=IF(LOWER(A1)="success","๐ŸŽŠ",IF(LOWER(A1)="error","๐Ÿ’ฅ","โš ๏ธ"))

๐ŸŽŠ

IF LOWER

Healthy / Sick wellness

=IF(LOWER(A1)="healthy","๐Ÿ’ช",IF(LOWER(A1)="sick","๐Ÿค’","๐Ÿคง"))

๐Ÿ’ช

IF LOWER

Up / Down votes

=IF(LOWER(A1)="up","โฌ†๏ธ",IF(LOWER(A1)="down","โฌ‡๏ธ","โžก๏ธ"))

โฌ†๏ธ

IF LOWER

Ready / Not ready checklist

=IF(LOWER(A1)="ready","โœ…",IF(LOWER(A1)="not ready","๐Ÿ“‹","๐Ÿ“"))

โœ…

IF LOWER

Available / Busy calendar

=IF(LOWER(A1)="available","โœจ",IF(LOWER(A1)="busy","๐Ÿ”ฅ","๐Ÿ“…"))

โœจ

IF LOWER

Yes / No checkmarks

=IF(A1="Yes",CHAR(10004)&" Yes","โœ— No")

โœ” Yes

IF CHAR

Yes / No with light check mark

=IF(A1="Yes",CHAR(10003)&" Yes",CHAR(10007)&" No")

โœ“ Yes

IF CHAR

Yes / No with heavy ballot X

=IF(A1="Yes",CHAR(10004)&" Yes",CHAR(10008)&" No")

โœ” Yes

IF CHAR

Yes / No with multiplication X

=IF(A1="Yes",CHAR(10003)&" Yes",CHAR(10006)&" No")

โœ“ Yes

IF CHAR

Yes / No ballot boxes

=IF(A1="Yes",CHAR(9745)&" Yes",CHAR(9744)&" No")

โ˜‘ Yes

IF CHAR

Yes / No ballot box and X box

=IF(A1="Yes",CHAR(9745)&" Yes",CHAR(9746)&" No")

โ˜‘ Yes

IF CHAR

Yes / No checkbox only

=IF(A1="Yes",CHAR(9745),CHAR(9744))

โ˜‘

IF CHAR

TRUE / FALSE checkbox

=IF(A1=TRUE,CHAR(9745),CHAR(9744))

โ˜‘

IF CHAR

Yes / No emoji checks

=IF(A1="Yes","โœ… Yes","โŒ No")

โœ… Yes

IF

Yes / No check glyphs only

=IF(A1="Yes",CHAR(10004),CHAR(10007))

โœ”

IF CHAR

Yes / No case-insensitive checks

=IF(LOWER(A1)="yes",CHAR(10004)&" Yes",CHAR(10007)&" No")

โœ” Yes

IF LOWER CHAR

Done / Todo checkmarks

=IF(LOWER(A1)="done",CHAR(10004)&" Done",CHAR(10007)&" Todo")

โœ” Done

IF LOWER CHAR

Approved / Rejected checkmarks

=IF(LOWER(A1)="approved",CHAR(10004)&" Approved",CHAR(10008)&" Rejected")

โœ” Approved

IF LOWER CHAR

Pass / Fail checkmarks

=IF(LOWER(A1)="pass",CHAR(10003)&" Pass",CHAR(10007)&" Fail")

โœ“ Pass

IF LOWER CHAR

Complete / Incomplete checkmarks

=IF(LOWER(A1)="complete",CHAR(10004)&" Complete",CHAR(9744)&" Incomplete")

โœ” Complete

IF LOWER CHAR

Checked / Unchecked with labels

=IF(LOWER(A1)="checked",CHAR(9745)&" Checked",CHAR(9744)&" Unchecked")

โ˜‘ Checked

IF LOWER CHAR

Heavy check or empty for Yes

=IF(A1="Yes",CHAR(10004),"")

โœ”

IF CHAR

Trend arrows

=IF(A1>0,"โ–ฒ "&A1,IF(A1<0,"โ–ผ "&A1,"โ†’ 0"))

โ–ฒ 12

IF

Braille micro-bar

=REPT("โ ฟ",A1)&REPT("โ €",5-A1)

โ ฟโ ฟโ ฟโ €โ €

REPT

Battery level

=REPT("โ–ˆ",MIN(5,MAX(0,ROUND(A1*5/100,0))))&REPT("โ–‘",5-MIN(5,MAX(0,ROUND(A1*5/100,0))))&" "&A1&"%"

โ–ˆโ–ˆโ–ˆโ–‘โ–‘ 60%

REPT ROUND MIN MAX

Heart health bar

=REPT("โ™ฅ",A1)&REPT("โ™ก",5-A1)

โ™ฅโ™ฅโ™ฅโ™กโ™ก

REPT

Sound level meter

=LEFT("โ–โ–‚โ–ƒโ–„โ–…โ–†โ–‡โ–ˆ",MIN(A1,8))

โ–โ–‚โ–ƒโ–„โ–…

LEFT MIN

Loading dots

=REPT("โ—",MOD(NOW()*86400,4))&REPT("โ—‹",4-MOD(NOW()*86400,4))

โ—โ—โ—‹โ—‹

REPT MOD NOW

12-hour clock dots

=REPT("โ—",HOUR(NOW()))&REPT("โ—‹",12-HOUR(NOW()))

โ—โ—โ—โ—โ—โ—โ—‹โ—‹โ—‹โ—‹โ—‹โ—‹

REPT NOW HOUR

24-hour clock dots

=REPT("โ—",HOUR(NOW()))&REPT("โ—‹",24-HOUR(NOW()))

โ—โ—โ—โ—โ—โ—โ—โ—โ—โ—โ—โ—โ—โ—โ—‹โ—‹โ—‹โ—‹โ—‹โ—‹โ—‹โ—‹โ—‹โ—‹

REPT NOW HOUR

Hour hand arrow

=CHOOSE(MOD(HOUR(NOW()),12)+1,"โ†‘","โ†—","โ†—","โ†’","โ†˜","โ†˜","โ†“","โ†™","โ†™","โ†","โ†–","โ†–")

โ†—

CHOOSE HOUR NOW

Minute hand arrow

=CHOOSE(MOD(QUOTIENT(MINUTE(NOW()),5),12)+1,"โ†‘","โ†—","โ†—","โ†’","โ†˜","โ†˜","โ†“","โ†™","โ†™","โ†","โ†–","โ†–")

โ†’

CHOOSE MINUTE NOW

Second hand spinner

=CHOOSE(MOD(NOW()*86400,8)+1,"โ†‘","โ†—","โ†’","โ†˜","โ†“","โ†™","โ†","โ†–")

โ†˜

CHOOSE MOD NOW SECOND

Clock hands as arrows

=CHOOSE(MOD(HOUR(NOW()),12)+1,"โ†‘","โ†—","โ†—","โ†’","โ†˜","โ†˜","โ†“","โ†™","โ†™","โ†","โ†–","โ†–")&"โ—Ž"&CHOOSE(MOD(QUOTIENT(MINUTE(NOW()),5),12)+1,"โ†‘","โ†—","โ†—","โ†’","โ†˜","โ†˜","โ†“","โ†™","โ†™","โ†","โ†–","โ†–")

โ†—โ—Žโ†’

CHOOSE HOUR MINUTE NOW

Clock face emoji

=CHOOSE(IF(MOD(HOUR(NOW()),12)=0,12,MOD(HOUR(NOW()),12)),"๐Ÿ•","๐Ÿ•‘","๐Ÿ•’","๐Ÿ•“","๐Ÿ•”","๐Ÿ••","๐Ÿ•–","๐Ÿ•—","๐Ÿ•˜","๐Ÿ•™","๐Ÿ•š","๐Ÿ•›")

๐Ÿ•—

CHOOSE HOUR NOW

Live time display

=TEXT(NOW(),"h:mm AM/PM")

8:00 AM

TEXT NOW

Spinning refresh arrow

=CHOOSE(MOD(NOW()*86400,4)+1,"โ†‘","โ†’","โ†“","โ†")

โ†’

CHOOSE MOD NOW

Counterclockwise spinning arrow

=CHOOSE(MOD(NOW()*86400,8)+1,"โ†‘","โ†–","โ†","โ†™","โ†“","โ†˜","โ†’","โ†—")

โ†™

CHOOSE MOD NOW

Second hand radar sweep

=REPT("ยท",SECOND(NOW()))&"โ†‘"&REPT("ยท",59-SECOND(NOW()))

ยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทโ†‘ยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยทยท

REPT SECOND NOW

Hour position on dial

=REPT("ยท",MOD(HOUR(NOW()),12))&"โ†‘"&REPT("ยท",11-MOD(HOUR(NOW()),12))

ยทยทยทยทยทยทยทโ†‘ยทยทยทยท

REPT HOUR NOW

Minute progress blocks

=REPT("โ–ˆ",QUOTIENT(MINUTE(NOW()),5))&REPT("โ–‘",12-QUOTIENT(MINUTE(NOW()),5))

โ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

REPT MINUTE NOW

Live hourglass flip

=IF(MOD(NOW()*86400,2)=0,CHAR(9203),CHAR(8987))

โณ

IF MOD NOW CHAR

Second countdown pulse

=REPT("โ—",MOD(60-SECOND(NOW()),10)+1)&REPT("โ—‹",10-MOD(60-SECOND(NOW()),10)-1)

โ—โ—โ—โ—โ—โ—‹โ—‹โ—‹โ—‹โ—‹

REPT MOD SECOND NOW

AM or PM indicator

=IF(HOUR(NOW())<12,"โ˜€๏ธ AM","๐ŸŒ™ PM")

โ˜€๏ธ AM

IF HOUR NOW

Time of day emoji

=SWITCH(TRUE,HOUR(NOW())<5,"๐ŸŒ™",HOUR(NOW())<8,"๐ŸŒ…",HOUR(NOW())<12,"โ˜€๏ธ",HOUR(NOW())<17,"๐ŸŒค๏ธ",HOUR(NOW())<20,"๐ŸŒ‡","๐ŸŒƒ")

๐ŸŒค๏ธ

SWITCH HOUR NOW

Time of day color dots

=SWITCH(TRUE,HOUR(NOW())<5,"โšซ",HOUR(NOW())<8,"๐ŸŸ ",HOUR(NOW())<17,"๐ŸŸก",HOUR(NOW())<20,"๐Ÿ”ด","โšซ")

๐ŸŸก

SWITCH HOUR NOW

Time of day routine

=SWITCH(TRUE,HOUR(NOW())<5,"๐Ÿ›๏ธ",HOUR(NOW())<9,"โ˜•",HOUR(NOW())<12,"๐Ÿ’ป",HOUR(NOW())<14,"๐Ÿ”",HOUR(NOW())<17,"๐Ÿ’ป",HOUR(NOW())<20,"๐Ÿฝ๏ธ",HOUR(NOW())<22,"๐Ÿ“บ","๐Ÿ›๏ธ")

โ˜•

SWITCH HOUR NOW

Sun and moon (6 to 6)

=IF(AND(HOUR(NOW())>=6,HOUR(NOW())<18),"โ˜€๏ธ","๐ŸŒ™")

โ˜€๏ธ

IF AND HOUR NOW

Weekday name from NOW

=TEXT(NOW(),"dddd")

Friday

TEXT NOW

Medal podium

=IF(A1=1,"๐Ÿฅ‡",IF(A1=2,"๐Ÿฅˆ",IF(A1=3,"๐Ÿฅ‰"," "&A1)))

๐Ÿฅ‡

IF

Dice face

=CHOOSE(A1,"โš€","โš","โš‚","โšƒ","โš„","โš…")

โš‚

CHOOSE

Random six-sided dice

=CHOOSE(RANDBETWEEN(1,6),"โš€","โš","โš‚","โšƒ","โš„","โš…")

โš‚

CHOOSE RANDBETWEEN

Dice face by name

=SWITCH(LOWER(A1),"one","โš€","two","โš","three","โš‚","four","โšƒ","five","โš„","six","โš…")

โš‚

SWITCH LOWER

Weather row

=IF(A1>80,"โ˜€๏ธ",IF(A1>50,"โ›…",IF(A1>20,"๐ŸŒง๏ธ","โ„๏ธ")))

โ›…

IF

Bullet list char

=CHAR(8226)&" "&B1

โ€ข Item

CHAR

Comma list to bullet points

=CHAR(8226)&" "&REGEXREPLACE(B1, ",\s*", CHAR(10)&CHAR(8226)&" ")

โ€ข Apple โ€ข Banana โ€ข Orange

CHAR REGEXREPLACE

Comma list to line breaks

=REGEXREPLACE(B1, ",\s*", CHAR(10))

Apple Banana Orange

REGEXREPLACE CHAR

Comma list to numbered lines

=TEXTJOIN(CHAR(10),TRUE,SEQUENCE(COUNTA(SPLIT(B1,",")))&". "&TRIM(SPLIT(B1,",")))

1. Apple 2. Banana 3. Orange

TEXTJOIN SEQUENCE SPLIT CHAR

Comma list to dash lines

="- "&REGEXREPLACE(B1, ",\s*", CHAR(10)&"- ")

- Apple - Banana - Orange

REGEXREPLACE CHAR

Comma list to checklist

=CHAR(9744)&" "&REGEXREPLACE(B1, ",\s*", CHAR(10)&CHAR(9744)&" ")

โ˜ Apple โ˜ Banana โ˜ Orange

CHAR REGEXREPLACE

Comma list to arrow lines

=CHAR(8594)&" "&REGEXREPLACE(B1, ",\s*", CHAR(10)&CHAR(8594)&" ")

โ†’ Apple โ†’ Banana โ†’ Orange

CHAR REGEXREPLACE

Comma list to star bullets

=CHAR(9733)&" "&REGEXREPLACE(B1, ",\s*", CHAR(10)&CHAR(9733)&" ")

โ˜… Apple โ˜… Banana โ˜… Orange

CHAR REGEXREPLACE

Comma list to indented bullets

=" "&CHAR(8226)&" "&REGEXREPLACE(B1, ",\s*", CHAR(10)&" "&CHAR(8226)&" ")

โ€ข Apple โ€ข Banana โ€ข Orange

CHAR REGEXREPLACE

Comma list to double-spaced lines

=REGEXREPLACE(B1, ",\s*", CHAR(10)&CHAR(10))

Apple Banana Orange

REGEXREPLACE CHAR

Pipe list to line breaks

=REGEXREPLACE(B1, "\|\s*", CHAR(10))

Apple Banana Orange

REGEXREPLACE CHAR

Semicolon list to bullet points

=CHAR(8226)&" "&REGEXREPLACE(B1, ";\s*", CHAR(10)&CHAR(8226)&" ")

โ€ข Apple โ€ข Banana โ€ข Orange

CHAR REGEXREPLACE

Text with underline

=A1&CHAR(10)&REPT("โ”€",LEN(A1))

Title โ”€โ”€โ”€โ”€โ”€

LEN REPT CHAR

Centered text in cell

=REPT(" ",MAX(0,INT((B1-LEN(A1))/2)))&A1

Hello

REPT LEN

Right-aligned text in cell

=REPT(" ",MAX(0,B1-LEN(A1)))&A1

Hi

REPT LEN

Section title with rules

=REPT("โ•",A1)&CHAR(10)&B1&CHAR(10)&REPT("โ•",A1)

โ•โ•โ•โ•โ•โ•โ•โ• Notes โ•โ•โ•โ•โ•โ•โ•โ•

REPT CHAR

Table row with pipes

="| "&A1&" | "&B1&" | "&C1&" |"

| Name | Qty | Price |

LEN

Table column header line

="โ”œ"&REPT("โ”€",LEN(A1)+2)&"โ”ค"&CHAR(10)&"โ”‚ "&A1&" โ”‚"

โ”œโ”€โ”€โ”€โ”€โ”€โ”ค โ”‚ Qty โ”‚

LEN REPT CHAR

Grid top border

="โ”Œ"&REPT("โ”€",A1)&"โ”ฌ"&REPT("โ”€",B1)&"โ”"

โ”Œโ”€โ”€โ”€โ”ฌโ”€โ”€โ”€โ”

REPT

Grid middle row

="โ”œ"&REPT("โ”€",A1)&"โ”ผ"&REPT("โ”€",B1)&"โ”ค"

โ”œโ”€โ”€โ”€โ”ผโ”€โ”€โ”€โ”ค

REPT

Left T divider

=REPT("โ”€",A1)&"โ”œ"&REPT("โ”€",A1)

โ”€โ”€โ”€โ”€โ”œโ”€โ”€โ”€โ”€

REPT

Right T divider

=REPT("โ”€",A1)&"โ”ค"&REPT("โ”€",A1)

โ”€โ”€โ”€โ”€โ”คโ”€โ”€โ”€โ”€

REPT

L-shaped corner

="โ””"&REPT("โ”€",A1)

โ””โ”€โ”€โ”€โ”€

REPT

Three-line menu icon

=REPT("โ•",A1)&CHAR(10)&REPT("โ•",A1)&CHAR(10)&REPT("โ•",A1)

โ•โ•โ• โ•โ•โ• โ•โ•โ•

REPT CHAR

Bracket label wrap

="["&" "&A1&" "&"]"

[ Hello ]

LEN

Curly quote wrap

=CHAR(8220)&A1&CHAR(8221)

โ€œHelloโ€

CHAR

Ellipsis truncate

=IF(LEN(A1)>B1,LEFT(A1,B1-3)&"...",A1)

Long sentence...

IF LEN LEFT

Box border cell

="โ”Œ"&REPT("โ”€",A1)&"โ”"&CHAR(10)&"โ”‚"&REPT(" ",A1)&"โ”‚"&CHAR(10)&"โ””"&REPT("โ”€",A1)&"โ”˜"

โ”Œโ”€โ”€โ”€โ”€โ” โ”‚ โ”‚ โ””โ”€โ”€โ”€โ”€โ”˜

REPT CHAR

Surround by ASCII

=CHAR(9556)&REPT(CHAR(9552),LEN(A1)+2)&CHAR(9559)&CHAR(10)&A1&CHAR(10)&CHAR(9562)&REPT(CHAR(9552),LEN(A1)+2)&CHAR(9565)

โ•”โ•โ•โ•โ•โ•โ•โ•โ•— Hello โ•šโ•โ•โ•โ•โ•โ•โ•โ•

REPT LEN CHAR

Rounded border cell

="โ•ญ"&REPT("โ”€",A1)&"โ•ฎ"&CHAR(10)&"โ”‚"&REPT(" ",A1)&"โ”‚"&CHAR(10)&"โ•ฐ"&REPT("โ”€",A1)&"โ•ฏ"

โ•ญโ”€โ”€โ”€โ”€โ•ฎ โ”‚ โ”‚ โ•ฐโ”€โ”€โ”€โ”€โ•ฏ

REPT CHAR

Heavy border cell

="โ”"&REPT("โ”",A1)&"โ”“"&CHAR(10)&"โ”ƒ"&REPT(" ",A1)&"โ”ƒ"&CHAR(10)&"โ”—"&REPT("โ”",A1)&"โ”›"

โ”โ”โ”โ”โ”โ”“ โ”ƒ โ”ƒ โ”—โ”โ”โ”โ”โ”›

REPT CHAR

Text inside box

="โ”Œ"&REPT("โ”€",LEN(A1)+2)&"โ”"&CHAR(10)&"โ”‚ "&A1&" โ”‚"&CHAR(10)&"โ””"&REPT("โ”€",LEN(A1)+2)&"โ”˜"

โ”Œโ”€โ”€โ”€โ”€โ” โ”‚ Hi โ”‚ โ””โ”€โ”€โ”€โ”€โ”˜

LEN REPT CHAR

Text inside double box

="โ•”"&REPT("โ•",LEN(A1)+2)&"โ•—"&CHAR(10)&"โ•‘ "&A1&" โ•‘"&CHAR(10)&"โ•š"&REPT("โ•",LEN(A1)+2)&"โ•"

โ•”โ•โ•โ•โ•โ•โ•โ•โ•— โ•‘ Hello โ•‘ โ•šโ•โ•โ•โ•โ•โ•โ•โ•

LEN REPT CHAR

Header box

="โ”"&REPT("โ”",LEN(A1)+2)&"โ”“"&CHAR(10)&"โ”ƒ "&A1&" โ”ƒ"

โ”โ”โ”โ”โ”โ”โ”โ”โ”“ โ”ƒ Title โ”ƒ

LEN REPT CHAR

Side border panel

=REPT("โ”‚"&REPT(" ",A1)&"โ”‚"&CHAR(10),B1-1)&"โ”‚"&REPT(" ",A1)&"โ”‚"

โ”‚ โ”‚ โ”‚ โ”‚ โ”‚ โ”‚

REPT CHAR

Horizontal rule

=REPT("โ”€",A1)

โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€

REPT

Dashed horizontal rule

=REPT("โ”„",A1)

โ”„โ”„โ”„โ”„โ”„โ”„โ”„โ”„

REPT

Vertical divider

=REPT("โ”‚"&CHAR(10),A1-1)&"โ”‚"

โ”‚ โ”‚ โ”‚ โ”‚

REPT CHAR

T-section divider

=REPT("โ”€",A1)&"โ”ฌ"&REPT("โ”€",A1)

โ”€โ”€โ”€โ”€โ”ฌโ”€โ”€โ”€โ”€

REPT

Cross divider

=REPT("โ”€",A1)&"โ”ผ"&REPT("โ”€",A1)

โ”€โ”€โ”€โ”€โ”ผโ”€โ”€โ”€โ”€

REPT

ASCII billboard

="โ”Œ"&REPT("โ”€",LEN(A1)+2)&"โ”"&CHAR(10)&"โ”‚ "&A1&" โ”‚"&CHAR(10)&"โ””"&REPT("โ”€",INT((LEN(A1)+2)/2))&"โ”ด"&REPT("โ”€",LEN(A1)+2-INT((LEN(A1)+2)/2)-1)&"โ”˜"&CHAR(10)&REPT(" ",1+INT((LEN(A1)+2)/2))&"โ”‚"&CHAR(10)&REPT(" ",1+INT((LEN(A1)+2)/2))&"โ”‚"

โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ” โ”‚ SALE โ”‚ โ””โ”€โ”€โ”€โ”ดโ”€โ”€โ”˜ โ”‚ โ”‚

LEN REPT CHAR

Goal posts

=" โ”‚"&REPT(" ",LEN(A1)+4)&"โ”‚"&CHAR(10)&" โ”‚"&REPT(" ",LEN(A1)+4)&"โ”‚"&CHAR(10)&" โ”‚ "&A1&REPT(" ",LEN(A1)+4-LEN(A1)-1)&"โ”‚"&CHAR(10)&"โ”€โ”ด"&REPT("โ”€",LEN(A1)+4)&"โ”ดโ”€"

โ”‚ โ”‚ โ”‚ โ”‚ โ”‚ GOAL โ”‚ โ”€โ”ดโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”ดโ”€

LEN REPT CHAR

Hanging sign

="โ”‚"&REPT(" ",LEN(A1)+14)&"โ”‚"&CHAR(10)&"โ•ฐ"&REPT("โ”€",INT((LEN(A1)+14)/2))&"โ”ฌ"&REPT("โ”€",LEN(A1)+14-INT((LEN(A1)+14)/2))&"โ•ฏ"&CHAR(10)&REPT(" ",INT((LEN(A1)+16)/2))&"โ”‚"&CHAR(10)&REPT(" ",INT((LEN(A1)+16)/2)-INT((LEN(A1)+6)/2))&"โ”Œ"&REPT("โ”€",INT((LEN(A1)+2)/2))&"โ”ด"&REPT("โ”€",LEN(A1)+2-INT((LEN(A1)+2)/2))&"โ”"&CHAR(10)&REPT(" ",INT((LEN(A1)+16)/2)-INT((LEN(A1)+6)/2))&"โ”‚ "&A1&" โ”‚"&CHAR(10)&REPT(" ",INT((LEN(A1)+16)/2)-INT((LEN(A1)+6)/2))&"โ””"&REPT("โ”€",LEN(A1)+2)&"โ”˜"

โ”‚ โ”‚ โ•ฐโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”ฌโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ•ฏ โ”‚ โ”Œโ”€โ”€โ”€โ”ดโ”€โ”€โ”€โ” โ”‚ OPEN โ”‚ โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”˜

LEN REPT CHAR

Surround text with skulls

=REPT("๐Ÿ’€",LEN(A1)+2)&CHAR(10)&"๐Ÿ’€ "&A1&" ๐Ÿ’€"&CHAR(10)&REPT("๐Ÿ’€",LEN(A1)+2)

๐Ÿ’€๐Ÿ’€๐Ÿ’€๐Ÿ’€๐Ÿ’€ ๐Ÿ’€ hi ๐Ÿ’€ ๐Ÿ’€๐Ÿ’€๐Ÿ’€๐Ÿ’€๐Ÿ’€

REPT LEN CHAR

Surround text with warning signs

=REPT("โš ๏ธ",LEN(A1)+2)&CHAR(10)&"โš ๏ธ "&A1&" โš ๏ธ"&CHAR(10)&REPT("โš ๏ธ",LEN(A1)+2)

โš ๏ธโš ๏ธโš ๏ธโš ๏ธโš ๏ธ โš ๏ธ hi โš ๏ธ โš ๏ธโš ๏ธโš ๏ธโš ๏ธโš ๏ธ

REPT LEN CHAR

Surround text with hearts

=REPT("โค๏ธ",LEN(A1)+2)&CHAR(10)&"โค๏ธ "&A1&" โค๏ธ"&CHAR(10)&REPT("โค๏ธ",LEN(A1)+2)

โค๏ธโค๏ธโค๏ธโค๏ธโค๏ธ โค๏ธ hi โค๏ธ โค๏ธโค๏ธโค๏ธโค๏ธโค๏ธ

REPT LEN CHAR

Surround text with flames

=REPT("๐Ÿ”ฅ",LEN(A1)+2)&CHAR(10)&"๐Ÿ”ฅ "&A1&" ๐Ÿ”ฅ"&CHAR(10)&REPT("๐Ÿ”ฅ",LEN(A1)+2)

๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ ๐Ÿ”ฅ hi ๐Ÿ”ฅ ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ

REPT LEN CHAR

Upside down text with CHAR

=TEXTJOIN("",TRUE,MAP(SEQUENCE(LEN(A1)),LAMBDA(i,SWITCH(MID(A1,LEN(A1)-i+1,1),"a",CHAR(592),"b","q","c",CHAR(596),"d","p","e",CHAR(477),"f",CHAR(607),"g",CHAR(387),"h",CHAR(613),"i",CHAR(7425),"j",CHAR(638),"k",CHAR(670),"l","l","m",CHAR(623),"n","u","o","o","p","d","q","b","r",CHAR(633),"s","s","t",CHAR(647),"u","n","v",CHAR(652),"w",CHAR(653),"x","x","y",CHAR(654),"z","z","A",CHAR(8704),"C",CHAR(390),"E",CHAR(398),"F",CHAR(8498),"L",CHAR(741),"M","W","P","d","T",CHAR(8868),"U",CHAR(8745),"V",CHAR(923),"Y",CHAR(8516),"0","0","1",CHAR(406),"2",CHAR(8586),"3",CHAR(8587),"5",CHAR(987),"6","9","7",CHAR(12581),"9","6",".",CHAR(729),"!",CHAR(161),"?",CHAR(191),"(",")",")","(",MID(A1,LEN(A1)-i+1,1)))))

ollวษฅ

CHAR MAP TEXTJOIN SEQUENCE SWITCH LAMBDA MID LEN

Sparkline blocks

=REPT("โ–ˆ",A1)&REPT("โ–",10-A1)

โ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–โ–โ–โ–โ–

REPT

Mood faces

=CHOOSE(A1,"๐Ÿ˜ข","๐Ÿ˜•","๐Ÿ˜","๐Ÿ™‚","๐Ÿ˜„")

๐Ÿ™‚

CHOOSE

Password strength

=REPT("โ–ˆ",A1)&REPT("โ–‘",5-A1)&" "&IF(A1>=4,"Strong",IF(A1>=2,"OK","Weak"))

โ–ˆโ–ˆโ–ˆโ–‘โ–‘ OK

REPT IF

Tree growth stages

=CHOOSE(MIN(A1,4),"๐ŸŒฑ","๐ŸŒฟ","๐ŸŒณ","๐ŸŒฒ","๐ŸŒฒ")

๐ŸŒณ

CHOOSE MIN

Growth completion by percentage

=CHOOSE(IF(A1>=100,5,IF(A1>75,4,IF(A1>50,3,IF(A1>25,2,1)))),"๐ŸŒฑ","๐ŸŒฟ","๐ŸŒณ","๐ŸŒฒ","๐ŸŒฒ")

๐ŸŒฑ๐ŸŒฟ๐ŸŒณ๐ŸŒฒ๐ŸŒฒ

IF CHOOSE

Arrow compass

=CHOOSE(A1,"โ†‘","โ†—","โ†’","โ†˜","โ†“","โ†™","โ†","โ†–")

โ†’

CHOOSE

Compass direction arrows

=SWITCH(A1,"North",CHAR(8593),"North East",CHAR(8599),"East",CHAR(8594),"South East",CHAR(8600),"South",CHAR(8595),"South West",CHAR(8601),"West",CHAR(8592),"North West",CHAR(8598))

North โ†’ โ†‘

SWITCH CHAR

Snail race to finish

=REPT("ยท",A1)&"๐ŸŒ"&REPT("ยท",MAX(0,10-A1))&"๐Ÿ"

ยทยทยท๐ŸŒยทยทยทยทยทยท๐Ÿ

REPT MAX

Poop races to the toilet

=REPT("ยท",A1)&"๐Ÿ’ฉ"&REPT("ยท",MAX(0,10-A1))&"๐Ÿšฝ"

ยทยทยท๐Ÿ’ฉยทยทยทยทยทยทยท๐Ÿšฝ

REPT MAX

Rocket launch pad

=REPT("ยท",MAX(0,8-A1))&"๐Ÿš€"&REPT(CHAR(9650),A1)

ยทยทยทยทยท๐Ÿš€โ–ฒโ–ฒโ–ฒ

REPT MAX CHAR

Fire intensity meter

=REPT("๐Ÿ”ฅ",A1)&REPT("โ—‹",5-A1)

๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅโ—‹โ—‹

REPT

Coffee cup counter

=REPT("โ˜•",A1)&REPT("โ—‹",5-A1)

โ˜•โ˜•โ˜•โ—‹โ—‹

REPT

Pizza slice tracker

=REPT("๐Ÿ•",A1)&" left"

๐Ÿ•๐Ÿ•๐Ÿ• left

REPT

Ice cream scoops

=REPT("๐Ÿฆ",A1)&REPT("ยท",5-A1)

๐Ÿฆ๐Ÿฆ๐Ÿฆยทยท

REPT

Hearts counter

=REPT("โค๏ธ",A1)&REPT("๐Ÿค",5-A1)

โค๏ธโค๏ธโค๏ธ๐Ÿค๐Ÿค

REPT

Mending hearts counter

=IF(A1<=0,REPT("๐Ÿค",5),IF(A1=1,REPT("๐Ÿ’”",1)&REPT("๐Ÿค",4),IF(A1<=3,REPT("โค๏ธโ€๐Ÿฉน",A1)&REPT("๐Ÿค",5-A1),REPT("โค๏ธ",A1)&REPT("๐Ÿค",5-A1))))

โค๏ธโ€๐Ÿฉนโค๏ธโ€๐Ÿฉน๐Ÿค๐Ÿค๐Ÿค

REPT IF

Hearts white to red counter

=IF(A1>=1,"โค๏ธ","๐Ÿค")&IF(A1>=2,"โค๏ธ","๐Ÿค")&IF(A1>=3,"โค๏ธ","๐Ÿค")&IF(A1>=4,"โค๏ธ","๐Ÿค")&IF(A1>=5,"โค๏ธ","๐Ÿค")

โค๏ธโค๏ธโค๏ธ๐Ÿค๐Ÿค

IF

Rainbow hearts counter

=IF(A1>=1,"โค๏ธ","๐Ÿค")&IF(A1>=2,"๐Ÿงก","๐Ÿค")&IF(A1>=3,"๐Ÿ’›","๐Ÿค")&IF(A1>=4,"๐Ÿ’š","๐Ÿค")&IF(A1>=5,"๐Ÿ’™","๐Ÿค")

โค๏ธ๐Ÿงก๐Ÿ’›๐Ÿค๐Ÿค

IF

Taco Tuesday count

=REPT("๐ŸŒฎ",A1)

๐ŸŒฎ๐ŸŒฎ๐ŸŒฎ

REPT

Taco Rating

=REPT("๐ŸŒฎ",A1)&" out of 5"

๐ŸŒฎ๐ŸŒฎ๐ŸŒฎ๐ŸŒฎ๐ŸŒฎ out of 5

REPT

Sushi plate rating

=REPT("๐Ÿฃ",A1)&REPT("โ—‹",5-A1)

๐Ÿฃ๐Ÿฃ๐Ÿฃโ—‹โ—‹

REPT

Colored book rating

=REPT("๐Ÿ“•",A1)&REPT("๐Ÿ“–",5-A1)

๐Ÿ“•๐Ÿ“•๐Ÿ“•๐Ÿ“–๐Ÿ“–

REPT

Book stack rating

=REPT("๐Ÿ“š",A1)&REPT("๐Ÿ“•",5-A1)

๐Ÿ“š๐Ÿ“š๐Ÿ“š๐Ÿ“•๐Ÿ“•

REPT

Fire rating

=REPT("๐Ÿ”ฅ",A1)&REPT("โ—‹",5-A1)

๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅโ—‹โ—‹

REPT

Coffee rating

=REPT("โ˜•",A1)&REPT("โ—‹",5-A1)

โ˜•โ˜•โ˜•โ—‹โ—‹

REPT

Thumbs up rating

=REPT("๐Ÿ‘",A1)&REPT("โ—‹",5-A1)

๐Ÿ‘๐Ÿ‘๐Ÿ‘โ—‹โ—‹

REPT

Thumbs up and down rating

=REPT("๐Ÿ‘",A1)&REPT("๐Ÿ‘Ž",5-A1)

๐Ÿ‘๐Ÿ‘๐Ÿ‘๐Ÿ‘Ž๐Ÿ‘Ž

REPT

Skull rating

=REPT("๐Ÿ’€",A1)&REPT("โ—‹",5-A1)

๐Ÿ’€๐Ÿ’€๐Ÿ’€โ—‹โ—‹

REPT

Hot dog and donut rating

=IF(A1=1,"๐ŸŒญ","๐Ÿฉ")

๐ŸŒญ

IF

Green apple go / red apple no

=IF(OR(LOWER(A1)="yes",LOWER(A1)="go"),"๐Ÿ",IF(OR(LOWER(A1)="no",LOWER(A1)="stop"),"๐ŸŽ","๐Ÿคท"))

๐Ÿ

IF LOWER OR

Chess rank badge

=CHOOSE(A1,CHAR(9823),CHAR(9822),CHAR(9821),CHAR(9820),CHAR(9819),CHAR(9818))

โ™›

CHOOSE CHAR

Playing card suit

=CHOOSE(A1,CHAR(9824),CHAR(9829),CHAR(9830),CHAR(9827))

โ™ 

CHOOSE CHAR

Random card suit

=CHOOSE(RANDBETWEEN(1,4),CHAR(9824),CHAR(9829),CHAR(9830),CHAR(9827))

โ™ 

CHOOSE CHAR RANDBETWEEN

Gold bar vault

=REPT(CHAR(9619),A1)&REPT(CHAR(9617),5-A1)

โ–“โ–“โ–“โ–‘โ–‘

REPT CHAR

Wifi signal bars

=CHOOSE(A1,CHAR(9601),CHAR(9601)&CHAR(9602),CHAR(9604)&CHAR(9605),CHAR(9606)&CHAR(9607),REPT(CHAR(9608),4))

โ–„โ–…

REPT CHOOSE CHAR

Pin map journey

=REPT("ยท",A1)&"๐Ÿ“"&REPT("ยท",MAX(0,10-A1))&"๐Ÿ "

ยทยทยท๐Ÿ“ยทยทยทยท๐Ÿ 

REPT MAX

Ship sailing home

=REPT("๐ŸŒŠ",A1)&"โ›ต"&REPT("๐ŸŒŠ",MAX(0,8-A1))

๐ŸŒŠ๐ŸŒŠ๐ŸŒŠโ›ต๐ŸŒŠ๐ŸŒŠ๐ŸŒŠ๐ŸŒŠ

REPT MAX

Clap-o-meter

=REPT("๐Ÿ‘",A1)

๐Ÿ‘๐Ÿ‘๐Ÿ‘

REPT

Trophy shelf

=REPT("๐Ÿ†",A1)&REPT(CHAR(9734),5-A1)

๐Ÿ†๐Ÿ†โ˜†โ˜†โ˜†

REPT CHAR

Moon phase picker

=CHOOSE(A1,"๐ŸŒ‘","๐ŸŒ’","๐ŸŒ“","๐ŸŒ”","๐ŸŒ•","๐ŸŒ–","๐ŸŒ—","๐ŸŒ˜")

๐ŸŒ“

CHOOSE

Moon phase by name

=SWITCH(LOWER(A1),"new","๐ŸŒ‘","waxing crescent","๐ŸŒ’","first quarter","๐ŸŒ“","waxing gibbous","๐ŸŒ”","full","๐ŸŒ•","waning gibbous","๐ŸŒ–","last quarter","๐ŸŒ—","waning crescent","๐ŸŒ˜","๐ŸŒ‘")

๐ŸŒ•

SWITCH LOWER

Chicken life cycle

=CHOOSE(A1,"๐Ÿฅš","๐Ÿฃ","๐Ÿค","๐Ÿ”")

๐Ÿค

CHOOSE

Butterfly metamorphosis

=CHOOSE(A1,"๐Ÿฅš","๐Ÿ›","๐Ÿ›Œ","๐Ÿฆ‹")

๐Ÿฆ‹

CHOOSE

Dragon hatching

=CHOOSE(A1,"๐Ÿฅš","๐Ÿฃ","๐Ÿฒ","๐Ÿ‰")

๐Ÿฒ

CHOOSE

Storm brewing phases

=CHOOSE(A1,"โ˜€๏ธ","๐ŸŒค๏ธ","๐ŸŒฅ๏ธ","๐ŸŒง๏ธ","โ›ˆ๏ธ")

๐ŸŒง๏ธ

CHOOSE

Four seasons

=CHOOSE(A1,"๐ŸŒธ","โ˜€๏ธ","๐Ÿ‚","โ„๏ธ")

๐Ÿ‚

CHOOSE

Random season

=CHOOSE(RANDBETWEEN(1,4),"๐ŸŒธ","โ˜€๏ธ","๐Ÿ‚","โ„๏ธ")

๐Ÿ‚

CHOOSE RANDBETWEEN

Day arc phases

=CHOOSE(A1,"๐ŸŒƒ","๐ŸŒ…","โ˜€๏ธ","๐ŸŒค๏ธ","๐ŸŒ‡","๐ŸŒ™")

๐ŸŒ‡

CHOOSE

Water cycle phases

=CHOOSE(A1,"๐ŸŒŠ","โ˜€๏ธ","โ˜๏ธ","๐ŸŒง๏ธ")

โ˜๏ธ

CHOOSE

Project lifecycle

=CHOOSE(A1,"๐Ÿ’ก","๐Ÿ“","๐Ÿ”จ","โœ…","๐ŸŽ‰")

๐Ÿ”จ

CHOOSE

Treasure hunt story

=CHOOSE(A1,"๐Ÿ—บ๏ธ","โ›ต","๐Ÿ๏ธ","๐Ÿ•ณ๏ธ","๐Ÿ’ฐ")

๐Ÿ๏ธ

CHOOSE

Campfire growth

=CHOOSE(A1,"๐Ÿชต","โœจ","๐Ÿ”ฅ","๐Ÿ•๏ธ")

๐Ÿ”ฅ

CHOOSE

Soup cooking story

=CHOOSE(A1,"๐Ÿฅ•","๐Ÿฒ","๐Ÿฅฃ","๐Ÿ˜‹")

๐Ÿฒ

CHOOSE

Pizza baking stages

=CHOOSE(A1,"๐Ÿซ“","๐Ÿง€","๐Ÿ•","๐Ÿ˜‹")

๐Ÿ•

CHOOSE

Snowman building

=CHOOSE(A1,"โ„๏ธ","โ›„","๐Ÿงฃ","โ˜ƒ๏ธ")

โ›„

CHOOSE

Book reading progress

=CHOOSE(A1,"๐Ÿ“•","๐Ÿ“–","๐Ÿ“—","โœ…")

๐Ÿ“–

CHOOSE

Rocket launch story

=CHOOSE(A1,"๐Ÿ”ง","โ›ฝ","๐Ÿš€","๐Ÿ”ฅ","๐ŸŒŒ")

๐Ÿš€

CHOOSE

Cat affection levels

=CHOOSE(A1,"๐Ÿ˜พ","๐Ÿ˜ผ","๐Ÿ˜ธ","๐Ÿ˜ป")

๐Ÿ˜ธ

CHOOSE

Sick to well recovery

=CHOOSE(A1,"๐Ÿคง","๐Ÿค’","๐Ÿ’Š","๐Ÿฉบ","๐Ÿ˜Š")

๐Ÿ’Š

CHOOSE

Ocean depth zones

=CHOOSE(A1,"๐Ÿ–๏ธ","๐Ÿ ","๐Ÿ™","๐Ÿฆˆ","๐ŸŒ‘")

๐Ÿ™

CHOOSE

Reaction face picker

=CHOOSE(A1,"เฒ _เฒ ","ยฏ\_(ใƒ„)_/ยฏ","(โ–€ฬฟฤนฬฏโ–€ฬฟ ฬฟ)")

ยฏ\_(ใƒ„)_/ยฏ

CHOOSE

Random reaction face

=CHOOSE(RANDBETWEEN(1,3),"เฒ _เฒ ","ยฏ\_(ใƒ„)_/ยฏ","(โ–€ฬฟฤนฬฏโ–€ฬฟ ฬฟ)")

ยฏ\_(ใƒ„)_/ยฏ

CHOOSE RANDBETWEEN

Reaction face by name

=SWITCH(LOWER(A1),"stern","เฒ _เฒ ","shrug","ยฏ\_(ใƒ„)_/ยฏ","cool","(โ–€ฬฟฤนฬฏโ–€ฬฟ ฬฟ)","ยฏ\_(ใƒ„)_/ยฏ")

เฒ _เฒ 

SWITCH LOWER

Kaomoji outrage picker

=CHOOSE(A1,"(โ•ฏยฐโ–กยฐ)โ•ฏ๏ธต โ”ปโ”โ”ป","(ใƒŽเฒ ็›Šเฒ )ใƒŽๅฝกโ”ปโ”โ”ป","ส•โ€ขแดฅโ€ขส”","(ใฅ๏ฝกโ—•โ€ฟโ€ฟโ—•๏ฝก)ใฅ")

(โ•ฏยฐโ–กยฐ)โ•ฏ๏ธต โ”ปโ”โ”ป

CHOOSE

Planet picker

=CHOOSE(A1,"โ˜ฟ๏ธ","โ™€๏ธ","๐ŸŒ","โ™‚๏ธ","โ™ƒ","โ™„","โ™…","โ™†")

๐ŸŒ

CHOOSE

Zodiac sign picker

=CHOOSE(LOOKUP(MONTH(A1)*100+DAY(A1),{101,120,219,321,420,521,621,723,823,923,1023,1122,1222},{1,2,3,4,5,6,7,8,9,10,11,12,1}),"โ™‘","โ™’","โ™“","โ™ˆ","โ™‰","โ™Š","โ™‹","โ™Œ","โ™","โ™Ž","โ™","โ™")

โ™‹

CHOOSE LOOKUP MONTH DAY

Random zodiac sign

=CHOOSE(RANDBETWEEN(1,12),"โ™‘","โ™’","โ™“","โ™ˆ","โ™‰","โ™Š","โ™‹","โ™Œ","โ™","โ™Ž","โ™","โ™")

โ™‹

CHOOSE RANDBETWEEN

Fitness rank badges

=CHOOSE(A1,"๐Ÿฅ‰","๐Ÿฅˆ","๐Ÿฅ‡","๐Ÿ†")

๐Ÿฅ‡

CHOOSE

Umbrella rain test

=IF(A1>50,"โ˜” Wet","โ˜€ Dry")

โ˜” Wet

IF

Wind gust strength

=REPT("๐Ÿ’จ",A1)&REPT("ยท",5-A1)

๐Ÿ’จ๐Ÿ’จ๐Ÿ’จยทยท

REPT

Snowfall depth

=REPT("โ„",A1)&REPT("ยท",10-A1)

โ„โ„โ„โ„ยทยทยทยทยทยทยท

REPT

Thermometer strip

=REPT(CHAR(9619),A1)&REPT(CHAR(9617),10-A1)&" "&A1&CHAR(176)

โ–“โ–“โ–“โ–“โ–“โ–‘โ–‘โ–‘โ–‘โ–‘ 72ยฐ

REPT CHAR

Hourglass flip

=IF(MOD(A1,2)=0,CHAR(9203),CHAR(8987))

โณ

IF MOD CHAR

Alarm clock urgency

=REPT("โฐ",A1)&" Wake up!"

โฐโฐ Wake up!

REPT

Alarm hour match

=IF(HOUR(NOW())=A1,REPT("โฐ",3)&" Wake up!","๐Ÿ’ค Sleeping")

โฐโฐโฐ Wake up!

IF HOUR NOW REPT

Birthday candle count

=REPT("๐Ÿ•ฏ",A1)&"๐ŸŽ‚"

๐Ÿ•ฏ๐Ÿ•ฏ๐Ÿ•ฏ๐ŸŽ‚

REPT

Christmas star tree

=REPT(CHAR(9733),A1)&"๐ŸŽ„"&REPT("ยท",MAX(0,8-A1))

โ˜…โ˜…โ˜…๐ŸŽ„ยทยทยทยทยท

REPT MAX CHAR

Halloween pumpkin row

=REPT("๐ŸŽƒ",MIN(A1,5))

๐ŸŽƒ๐ŸŽƒ๐ŸŽƒ

REPT MIN

Easter egg hunt

=REPT("๐Ÿฅš",A1)&REPT("๐ŸŒฟ",5-A1)

๐Ÿฅš๐Ÿฅš๐Ÿฅš๐ŸŒฟ๐ŸŒฟ

REPT

Football field push

=REPT(CHAR(9619),A1)&"๐Ÿˆ"&REPT(CHAR(9617),10-A1)

โ–“โ–“โ–“๐Ÿˆโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

REPT CHAR

Basketball shots made

=REPT("๐Ÿ€",A1)&REPT("โ—‹",5-A1)

๐Ÿ€๐Ÿ€๐Ÿ€โ—‹โ—‹

REPT

Tennis rally counter

=REPT("๐ŸŽพ",A1)

๐ŸŽพ๐ŸŽพ๐ŸŽพ

REPT

Swimming lap tracker

=REPT("๐ŸŠ",1)&REPT("ใ€ฐ",A1)

๐ŸŠใ€ฐใ€ฐใ€ฐ

REPT

Yoga calm meter

=REPT("๐Ÿง˜",1)&REPT("ยท",A1)&REPT("โ˜ฎ",1)

๐Ÿง˜ยทยทยทโ˜ฎ

REPT

Reading page progress

=REPT("๐Ÿ“–",A1)&REPT("๐Ÿ“•",5-A1)

๐Ÿ“–๐Ÿ“–๐Ÿ“–๐Ÿ“•๐Ÿ“•

REPT

Email inbox pile

=REPT("๐Ÿ“ง",A1)&" unread"

๐Ÿ“ง๐Ÿ“ง๐Ÿ“ง unread

REPT

Piggy bank savings

=REPT("๐Ÿท",1)&REPT("๐Ÿ’ฐ",A1)

๐Ÿท๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ’ฐ

REPT

Light bulb ideas

=REPT("๐Ÿ’ก",A1)&REPT("โ—‹",5-A1)

๐Ÿ’ก๐Ÿ’ก๐Ÿ’กโ—‹โ—‹

REPT

Music note volume

=REPT(CHAR(9834),A1)&REPT(CHAR(9835),MAX(0,3-A1))

โ™ชโ™ชโ™ชโ™ซ

REPT MAX CHAR

Guitar solo intensity

=REPT("๐ŸŽธ",1)&REPT(CHAR(9834),A1)

๐ŸŽธโ™ชโ™ชโ™ช

REPT CHAR

Karaoke mic level

=REPT("๐ŸŽค",1)&REPT(CHAR(9601),A1)&REPT(CHAR(9608),5-A1)

๐ŸŽคโ–โ–โ–ˆโ–ˆโ–ˆ

REPT CHAR

Popcorn movie rating

=REPT("๐Ÿฟ",1)&REPT(CHAR(9733),A1)&REPT(CHAR(9734),5-A1)

๐Ÿฟโ˜…โ˜…โ˜…โ˜†โ˜†

REPT CHAR

Game controller lives

=REPT("๐ŸŽฎ",A1)&REPT("โœ—",3-A1)

๐ŸŽฎ๐ŸŽฎ๐ŸŽฎ

REPT

Puzzle pieces solved

=REPT("๐Ÿงฉ",A1)&REPT("โ–ก",9-A1)

๐Ÿงฉ๐Ÿงฉ๐Ÿงฉโ–กโ–กโ–กโ–กโ–กโ–ก

REPT

Slot machine cherries

=REPT("๐Ÿ’",A1)&REPT("๐Ÿ‹",3-A1)

๐Ÿ’๐Ÿ’๐Ÿ‹

REPT

Dragon HP bar

=REPT(CHAR(9829),MIN(A1,5))&REPT(CHAR(9608),MAX(0,A1-5))&REPT(CHAR(9617),10-A1)&" ๐Ÿ‰"

โ™ฅโ™ฅโ–ˆโ–‘โ–‘ ๐Ÿ‰

REPT MIN MAX CHAR

Wizard sparkle level

=REPT("๐Ÿง™",1)&REPT("โœจ",A1)

๐Ÿง™โœจโœจโœจ

REPT

Castle wall defense

=REPT(CHAR(9608),A1)&"๐Ÿฐ"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐Ÿฐโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

REPT CHAR

Fence perimeter defense

=REPT(CHAR(9608),A1)&"๐Ÿšง"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐Ÿšงโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

REPT CHAR

Home fortification

=REPT(CHAR(9608),A1)&"๐Ÿ "&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐Ÿ โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

REPT CHAR

Forest tree line

=REPT(CHAR(9608),A1)&"๐ŸŒฒ"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐ŸŒฒโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

REPT CHAR

Bank vault barrier

=REPT(CHAR(9619),A1)&"๐Ÿฆ"&REPT(CHAR(9617),10-A1)

โ–“โ–“โ–“๐Ÿฆโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

REPT CHAR

Brick wall gate

=REPT("๐Ÿงฑ",A1)&"๐Ÿšช"&REPT(CHAR(9617),10-A1)

๐Ÿงฑ๐Ÿงฑ๐Ÿงฑ๐Ÿšชโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

REPT CHAR

Garden fence gate

=REPT(CHAR(9608),A1)&"๐ŸŒท"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐ŸŒทโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

REPT CHAR

Camp perimeter wall

=REPT(CHAR(9608),A1)&"โ›บ"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆโ›บโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

REPT CHAR

Treasure hoard guard

=REPT(CHAR(9608),A1)&"๐Ÿ’ฐ"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐Ÿ’ฐโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

REPT CHAR

Soccer goal defense

=REPT(CHAR(9608),A1)&"๐Ÿฅ…"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐Ÿฅ…โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

REPT CHAR

Random sport

=CHOOSE(RANDBETWEEN(1,6),"๐Ÿˆ","๐Ÿ€","๐ŸŽพ","๐ŸŠ","๐Ÿง˜","โšฝ")

๐Ÿ€

CHOOSE RANDBETWEEN

Beehive barrier

=REPT(CHAR(9608),A1)&"๐Ÿฏ"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐Ÿฏโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

REPT CHAR

Harbor dock wall

=REPT(CHAR(9608),A1)&"โš“"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆโš“โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

REPT CHAR

Barn paddock fence

=REPT(CHAR(9608),A1)&"๐Ÿ„"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐Ÿ„โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

REPT CHAR

Hospital ward barrier

=REPT(CHAR(9608),A1)&"๐Ÿฅ"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐Ÿฅโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

REPT CHAR

School yard fence

=REPT(CHAR(9608),A1)&"๐Ÿซ"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐Ÿซโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

REPT CHAR

Space base shield

=REPT(CHAR(9608),A1)&"๐Ÿš€"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐Ÿš€โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

REPT CHAR

Seed to sunflower

=CHOOSE(A1,"๐ŸŒฐ","๐ŸŒฑ","๐ŸŒฟ","๐ŸŒป","๐ŸŒป")

๐ŸŒป

CHOOSE

Wood to fire to ash

=IF(A1<=3,REPT("๐Ÿชต",A1)&REPT("โ–‘",10-A1),IF(A1<=7,REPT("๐Ÿชต",3)&REPT("๐Ÿ”ฅ",A1-3)&REPT("โ–‘",10-A1),REPT("๐Ÿชต",3)&REPT("๐Ÿ”ฅ",4)&REPT("โฌ›",A1-7)&REPT("โ–‘",10-A1)))

๐Ÿชต๐Ÿชต๐Ÿชต๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅโฌ›โฌ›โ–‘

IF REPT

Seedling to flower bloom

=IF(A1<=3,REPT("๐ŸŒฑ",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐ŸŒฑ",3)&REPT("๐ŸŒฟ",A1-3)&REPT("โ–‘",10-A1),REPT("๐ŸŒฑ",3)&REPT("๐ŸŒฟ",3)&REPT("๐ŸŒธ",A1-6)&REPT("โ–‘",10-A1)))

๐ŸŒฑ๐ŸŒฑ๐ŸŒฑ๐ŸŒฟ๐ŸŒฟ๐ŸŒฟ๐ŸŒธ๐ŸŒธโ–‘โ–‘

IF REPT

Cow herd to milk

=IF(A1<=5,REPT("๐Ÿ„",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ„",5)&REPT("๐Ÿฅ›",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ„๐Ÿ„๐Ÿ„๐Ÿ„๐Ÿ„๐Ÿฅ›๐Ÿฅ›๐Ÿฅ›โ–‘โ–‘

IF REPT

Egg to chicken

=IF(A1<=3,REPT("๐Ÿฅš",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐Ÿฅš",3)&REPT("๐Ÿฃ",A1-3)&REPT("โ–‘",10-A1),REPT("๐Ÿฅš",3)&REPT("๐Ÿฃ",3)&REPT("๐Ÿ”",A1-6)&REPT("โ–‘",10-A1)))

๐Ÿฅš๐Ÿฅš๐Ÿฅš๐Ÿฃ๐Ÿฃ๐Ÿฃ๐Ÿ”๐Ÿ”โ–‘โ–‘

IF REPT

Grapes to wine

=IF(A1<=5,REPT("๐Ÿ‡",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ‡",5)&REPT("๐Ÿท",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ‡๐Ÿ‡๐Ÿ‡๐Ÿ‡๐Ÿ‡๐Ÿท๐Ÿท๐Ÿทโ–‘โ–‘

IF REPT

Dough to bread

=IF(A1<=3,REPT("๐Ÿซ“",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐Ÿซ“",3)&REPT("๐Ÿ”ฅ",A1-3)&REPT("โ–‘",10-A1),REPT("๐Ÿซ“",3)&REPT("๐Ÿ”ฅ",3)&REPT("๐Ÿž",A1-6)&REPT("โ–‘",10-A1)))

๐Ÿซ“๐Ÿซ“๐Ÿซ“๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿž๐Ÿžโ–‘โ–‘

IF REPT

Caterpillar to butterfly

=IF(A1<=3,REPT("๐Ÿ›",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐Ÿ›",3)&REPT("๐Ÿ›Œ",A1-3)&REPT("โ–‘",10-A1),REPT("๐Ÿ›",3)&REPT("๐Ÿ›Œ",3)&REPT("๐Ÿฆ‹",A1-6)&REPT("โ–‘",10-A1)))

๐Ÿ›๐Ÿ›๐Ÿ›๐Ÿ›Œ๐Ÿ›Œ๐Ÿ›Œ๐Ÿฆ‹๐Ÿฆ‹โ–‘โ–‘

IF REPT

Wheat to toast

=IF(A1<=3,REPT("๐ŸŒพ",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐ŸŒพ",3)&REPT("๐Ÿซ“",A1-3)&REPT("โ–‘",10-A1),REPT("๐ŸŒพ",3)&REPT("๐Ÿซ“",3)&REPT("๐Ÿž",A1-6)&REPT("โ–‘",10-A1)))

๐ŸŒพ๐ŸŒพ๐ŸŒพ๐Ÿซ“๐Ÿซ“๐Ÿซ“๐Ÿž๐Ÿžโ–‘โ–‘

IF REPT

Bean to coffee cup

=IF(A1<=5,REPT("๐Ÿซ˜",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿซ˜",5)&REPT("โ˜•",A1-5)&REPT("โ–‘",10-A1))

๐Ÿซ˜๐Ÿซ˜๐Ÿซ˜๐Ÿซ˜๐Ÿซ˜โ˜•โ˜•โ˜•โ–‘โ–‘

IF REPT

Cocoa to chocolate

=IF(A1<=5,REPT("๐ŸŒฐ",A1)&REPT("โ–‘",10-A1),REPT("๐ŸŒฐ",5)&REPT("๐Ÿซ",A1-5)&REPT("โ–‘",10-A1))

๐ŸŒฐ๐ŸŒฐ๐ŸŒฐ๐ŸŒฐ๐ŸŒฐ๐Ÿซ๐Ÿซ๐Ÿซโ–‘โ–‘

IF REPT

Ice cube to puddle

=IF(A1<=5,REPT("๐ŸงŠ",A1)&REPT("โ–‘",10-A1),REPT("๐ŸงŠ",5)&REPT("๐Ÿ’ง",A1-5)&REPT("โ–‘",10-A1))

๐ŸงŠ๐ŸงŠ๐ŸงŠ๐ŸงŠ๐ŸงŠ๐Ÿ’ง๐Ÿ’ง๐Ÿ’งโ–‘โ–‘

IF REPT

Snow to snowman

=IF(A1<=6,REPT("โ„๏ธ",A1)&REPT("โ–‘",10-A1),REPT("โ„๏ธ",6)&REPT("โ›„",A1-6)&REPT("โ–‘",10-A1))

โ„๏ธโ„๏ธโ„๏ธโ„๏ธโ„๏ธโ„๏ธโ›„โ›„โ›„โ–‘

IF REPT

Cloud to rainfall

=IF(A1<=5,REPT("โ˜๏ธ",A1)&REPT("โ–‘",10-A1),REPT("โ˜๏ธ",5)&REPT("๐ŸŒง๏ธ",A1-5)&REPT("โ–‘",10-A1))

โ˜๏ธโ˜๏ธโ˜๏ธโ˜๏ธโ˜๏ธ๐ŸŒง๏ธ๐ŸŒง๏ธ๐ŸŒง๏ธโ–‘โ–‘

IF REPT

Fish to sushi

=IF(A1<=5,REPT("๐ŸŸ",A1)&REPT("โ–‘",10-A1),REPT("๐ŸŸ",5)&REPT("๐Ÿฃ",A1-5)&REPT("โ–‘",10-A1))

๐ŸŸ๐ŸŸ๐ŸŸ๐ŸŸ๐ŸŸ๐Ÿฃ๐Ÿฃ๐Ÿฃโ–‘โ–‘

IF REPT

Potato to fries

=IF(A1<=5,REPT("๐Ÿฅ”",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿฅ”",5)&REPT("๐ŸŸ",A1-5)&REPT("โ–‘",10-A1))

๐Ÿฅ”๐Ÿฅ”๐Ÿฅ”๐Ÿฅ”๐Ÿฅ”๐ŸŸ๐ŸŸ๐ŸŸโ–‘โ–‘

IF REPT

Tomato to pizza

=IF(A1<=5,REPT("๐Ÿ…",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ…",5)&REPT("๐Ÿ•",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ…๐Ÿ…๐Ÿ…๐Ÿ…๐Ÿ…๐Ÿ•๐Ÿ•๐Ÿ•โ–‘โ–‘

IF REPT

Bees to honey

=IF(A1<=5,REPT("๐Ÿ",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ",5)&REPT("๐Ÿฏ",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ๐Ÿ๐Ÿ๐Ÿ๐Ÿ๐Ÿฏ๐Ÿฏ๐Ÿฏโ–‘โ–‘

IF REPT

Milk to cheese

=IF(A1<=5,REPT("๐Ÿฅ›",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿฅ›",5)&REPT("๐Ÿง€",A1-5)&REPT("โ–‘",10-A1))

๐Ÿฅ›๐Ÿฅ›๐Ÿฅ›๐Ÿฅ›๐Ÿฅ›๐Ÿง€๐Ÿง€๐Ÿง€โ–‘โ–‘

IF REPT

Corn to popcorn

=IF(A1<=4,REPT("๐ŸŒฝ",A1)&REPT("โ–‘",10-A1),IF(A1<=7,REPT("๐ŸŒฝ",4)&REPT("๐Ÿ”ฅ",A1-4)&REPT("โ–‘",10-A1),REPT("๐ŸŒฝ",4)&REPT("๐Ÿ”ฅ",3)&REPT("๐Ÿฟ",A1-7)&REPT("โ–‘",10-A1)))

๐ŸŒฝ๐ŸŒฝ๐ŸŒฝ๐ŸŒฝ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿฟ๐Ÿฟโ–‘

IF REPT

Apple to pie

=IF(A1<=5,REPT("๐ŸŽ",A1)&REPT("โ–‘",10-A1),REPT("๐ŸŽ",5)&REPT("๐Ÿฅง",A1-5)&REPT("โ–‘",10-A1))

๐ŸŽ๐ŸŽ๐ŸŽ๐ŸŽ๐ŸŽ๐Ÿฅง๐Ÿฅง๐Ÿฅงโ–‘โ–‘

IF REPT

Pig to bacon

=IF(A1<=5,REPT("๐Ÿท",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿท",5)&REPT("๐Ÿฅ“",A1-5)&REPT("โ–‘",10-A1))

๐Ÿท๐Ÿท๐Ÿท๐Ÿท๐Ÿท๐Ÿฅ“๐Ÿฅ“๐Ÿฅ“โ–‘โ–‘

IF REPT

Coal to diamond

=IF(A1<=5,REPT("โฌ›",A1)&REPT("โ–‘",10-A1),REPT("โฌ›",5)&REPT("๐Ÿ’Ž",A1-5)&REPT("โ–‘",10-A1))

โฌ›โฌ›โฌ›โฌ›โฌ›๐Ÿ’Ž๐Ÿ’Ž๐Ÿ’Žโ–‘โ–‘

IF REPT

Lemon to lemonade

=IF(A1<=5,REPT("๐Ÿ‹",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ‹",5)&REPT("๐Ÿฅค",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ‹๐Ÿ‹๐Ÿ‹๐Ÿ‹๐Ÿ‹๐Ÿฅค๐Ÿฅค๐Ÿฅคโ–‘โ–‘

IF REPT

Seed to pumpkin

=IF(A1<=5,REPT("๐ŸŒฑ",A1)&REPT("โ–‘",10-A1),REPT("๐ŸŒฑ",5)&REPT("๐ŸŽƒ",A1-5)&REPT("โ–‘",10-A1))

๐ŸŒฑ๐ŸŒฑ๐ŸŒฑ๐ŸŒฑ๐ŸŒฑ๐ŸŽƒ๐ŸŽƒ๐ŸŽƒโ–‘โ–‘

IF REPT

Trash to recycling

=IF(A1<=5,REPT("๐Ÿ—‘๏ธ",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ—‘๏ธ",5)&REPT("โ™ป๏ธ",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ—‘๏ธ๐Ÿ—‘๏ธ๐Ÿ—‘๏ธ๐Ÿ—‘๏ธ๐Ÿ—‘๏ธโ™ป๏ธโ™ป๏ธโ™ป๏ธโ–‘โ–‘

IF REPT

Letter to mailbox

=IF(A1<=5,REPT("โœ‰๏ธ",A1)&REPT("โ–‘",10-A1),REPT("โœ‰๏ธ",5)&REPT("๐Ÿ“ฌ",A1-5)&REPT("โ–‘",10-A1))

โœ‰๏ธโœ‰๏ธโœ‰๏ธโœ‰๏ธโœ‰๏ธ๐Ÿ“ฌ๐Ÿ“ฌ๐Ÿ“ฌโ–‘โ–‘

IF REPT

Ore to gold

=IF(A1<=3,REPT("โ›๏ธ",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("โ›๏ธ",3)&REPT("๐Ÿชจ",A1-3)&REPT("โ–‘",10-A1),REPT("โ›๏ธ",3)&REPT("๐Ÿชจ",3)&REPT("๐Ÿ’ฐ",A1-6)&REPT("โ–‘",10-A1)))

โ›๏ธโ›๏ธโ›๏ธ๐Ÿชจ๐Ÿชจ๐Ÿชจ๐Ÿ’ฐ๐Ÿ’ฐโ–‘โ–‘

IF REPT

Brick to house

=IF(A1<=6,REPT("๐Ÿงฑ",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿงฑ",6)&REPT("๐Ÿ ",A1-6)&REPT("โ–‘",10-A1))

๐Ÿงฑ๐Ÿงฑ๐Ÿงฑ๐Ÿงฑ๐Ÿงฑ๐Ÿงฑ๐Ÿ ๐Ÿ ๐Ÿ โ–‘

IF REPT

Yarn to sweater

=IF(A1<=5,REPT("๐Ÿงถ",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿงถ",5)&REPT("๐Ÿงฅ",A1-5)&REPT("โ–‘",10-A1))

๐Ÿงถ๐Ÿงถ๐Ÿงถ๐Ÿงถ๐Ÿงถ๐Ÿงฅ๐Ÿงฅ๐Ÿงฅโ–‘โ–‘

IF REPT

Water to tea

=IF(A1<=3,REPT("๐Ÿ’ง",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐Ÿ’ง",3)&REPT("๐Ÿซ–",A1-3)&REPT("โ–‘",10-A1),REPT("๐Ÿ’ง",3)&REPT("๐Ÿซ–",3)&REPT("๐Ÿต",A1-6)&REPT("โ–‘",10-A1)))

๐Ÿ’ง๐Ÿ’ง๐Ÿ’ง๐Ÿซ–๐Ÿซ–๐Ÿซ–๐Ÿต๐Ÿตโ–‘โ–‘

IF REPT

Rock to gem

=IF(A1<=5,REPT("๐Ÿชจ",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿชจ",5)&REPT("๐Ÿ’Ž",A1-5)&REPT("โ–‘",10-A1))

๐Ÿชจ๐Ÿชจ๐Ÿชจ๐Ÿชจ๐Ÿชจ๐Ÿ’Ž๐Ÿ’Ž๐Ÿ’Žโ–‘โ–‘

IF REPT

Egg to omelette

=IF(A1<=3,REPT("๐Ÿฅš",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐Ÿฅš",3)&REPT("๐Ÿณ",A1-3)&REPT("โ–‘",10-A1),REPT("๐Ÿฅš",3)&REPT("๐Ÿณ",3)&REPT("๐Ÿฝ๏ธ",A1-6)&REPT("โ–‘",10-A1)))

๐Ÿฅš๐Ÿฅš๐Ÿฅš๐Ÿณ๐Ÿณ๐Ÿณ๐Ÿฝ๏ธ๐Ÿฝ๏ธโ–‘โ–‘

IF REPT

Sand to sandcastle

=IF(A1<=5,REPT("๐Ÿ–๏ธ",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ–๏ธ",5)&REPT("๐Ÿฐ",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ–๏ธ๐Ÿ–๏ธ๐Ÿ–๏ธ๐Ÿ–๏ธ๐Ÿ–๏ธ๐Ÿฐ๐Ÿฐ๐Ÿฐโ–‘โ–‘

IF REPT

Flour to cake

=IF(A1<=3,REPT("๐ŸŒพ",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐ŸŒพ",3)&REPT("๐Ÿ”ฅ",A1-3)&REPT("โ–‘",10-A1),REPT("๐ŸŒพ",3)&REPT("๐Ÿ”ฅ",3)&REPT("๐ŸŽ‚",A1-6)&REPT("โ–‘",10-A1)))

๐ŸŒพ๐ŸŒพ๐ŸŒพ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐ŸŽ‚๐ŸŽ‚โ–‘โ–‘

IF REPT

Cash to bank

=IF(A1<=3,REPT("๐Ÿ’ต",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐Ÿ’ต",3)&REPT("๐Ÿ’ฐ",A1-3)&REPT("โ–‘",10-A1),REPT("๐Ÿ’ต",3)&REPT("๐Ÿ’ฐ",3)&REPT("๐Ÿฆ",A1-6)&REPT("โ–‘",10-A1)))

๐Ÿ’ต๐Ÿ’ต๐Ÿ’ต๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿฆ๐Ÿฆโ–‘โ–‘

IF REPT

Coins to piggy bank

=IF(A1<=6,REPT("๐Ÿช™",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿช™",6)&REPT("๐Ÿท",A1-6)&REPT("โ–‘",10-A1))

๐Ÿช™๐Ÿช™๐Ÿช™๐Ÿช™๐Ÿช™๐Ÿช™๐Ÿท๐Ÿท๐Ÿทโ–‘

IF REPT

Paycheck to savings

=IF(A1<=3,REPT("๐Ÿ’ผ",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐Ÿ’ผ",3)&REPT("๐Ÿ’ต",A1-3)&REPT("โ–‘",10-A1),REPT("๐Ÿ’ผ",3)&REPT("๐Ÿ’ต",3)&REPT("๐Ÿฆ",A1-6)&REPT("โ–‘",10-A1)))

๐Ÿ’ผ๐Ÿ’ผ๐Ÿ’ผ๐Ÿ’ต๐Ÿ’ต๐Ÿ’ต๐Ÿฆ๐Ÿฆโ–‘โ–‘

IF REPT

Wallet to bank

=IF(A1<=5,REPT("๐Ÿ‘›",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ‘›",5)&REPT("๐Ÿฆ",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ‘›๐Ÿ‘›๐Ÿ‘›๐Ÿ‘›๐Ÿ‘›๐Ÿฆ๐Ÿฆ๐Ÿฆโ–‘โ–‘

IF REPT

Cart to checkout

=IF(A1<=6,REPT("๐Ÿ›’",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ›’",6)&REPT("๐Ÿ’ณ",A1-6)&REPT("โ–‘",10-A1))

๐Ÿ›’๐Ÿ›’๐Ÿ›’๐Ÿ›’๐Ÿ›’๐Ÿ›’๐Ÿ’ณ๐Ÿ’ณ๐Ÿ’ณโ–‘

IF REPT

Invoice to paid

=IF(A1<=4,REPT("๐Ÿ“„",A1)&REPT("โ–‘",10-A1),IF(A1<=7,REPT("๐Ÿ“„",4)&REPT("โœ…",A1-4)&REPT("โ–‘",10-A1),REPT("๐Ÿ“„",4)&REPT("โœ…",3)&REPT("๐Ÿ’ฐ",A1-7)&REPT("โ–‘",10-A1)))

๐Ÿ“„๐Ÿ“„๐Ÿ“„๐Ÿ“„โœ…โœ…โœ…๐Ÿ’ฐ๐Ÿ’ฐโ–‘

IF REPT

Rain to rainbow

=IF(A1<=5,REPT("๐ŸŒง๏ธ",A1)&REPT("โ–‘",10-A1),REPT("๐ŸŒง๏ธ",5)&REPT("๐ŸŒˆ",A1-5)&REPT("โ–‘",10-A1))

๐ŸŒง๏ธ๐ŸŒง๏ธ๐ŸŒง๏ธ๐ŸŒง๏ธ๐ŸŒง๏ธ๐ŸŒˆ๐ŸŒˆ๐ŸŒˆโ–‘โ–‘

IF REPT

Night to day

=IF(A1<=5,REPT("๐ŸŒ™",A1)&REPT("โ–‘",10-A1),REPT("๐ŸŒ™",5)&REPT("โ˜€๏ธ",A1-5)&REPT("โ–‘",10-A1))

๐ŸŒ™๐ŸŒ™๐ŸŒ™๐ŸŒ™๐ŸŒ™โ˜€๏ธโ˜€๏ธโ˜€๏ธโ–‘โ–‘

IF REPT

Candle to light bulb

=IF(A1<=5,REPT("๐Ÿ•ฏ๏ธ",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ•ฏ๏ธ",5)&REPT("๐Ÿ’ก",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ•ฏ๏ธ๐Ÿ•ฏ๏ธ๐Ÿ•ฏ๏ธ๐Ÿ•ฏ๏ธ๐Ÿ•ฏ๏ธ๐Ÿ’ก๐Ÿ’ก๐Ÿ’กโ–‘โ–‘

IF REPT

Wood to paper

=IF(A1<=5,REPT("๐Ÿชต",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿชต",5)&REPT("๐Ÿ“„",A1-5)&REPT("โ–‘",10-A1))

๐Ÿชต๐Ÿชต๐Ÿชต๐Ÿชต๐Ÿชต๐Ÿ“„๐Ÿ“„๐Ÿ“„โ–‘โ–‘

IF REPT

Sheep to yarn

=IF(A1<=5,REPT("๐Ÿ‘",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ‘",5)&REPT("๐Ÿงถ",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ‘๐Ÿ‘๐Ÿ‘๐Ÿ‘๐Ÿ‘๐Ÿงถ๐Ÿงถ๐Ÿงถโ–‘โ–‘

IF REPT

Oil barrel to gas pump

=IF(A1<=5,REPT("๐Ÿ›ข๏ธ",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ›ข๏ธ",5)&REPT("โ›ฝ",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ›ข๏ธ๐Ÿ›ข๏ธ๐Ÿ›ข๏ธ๐Ÿ›ข๏ธ๐Ÿ›ข๏ธโ›ฝโ›ฝโ›ฝโ–‘โ–‘

IF REPT

Seed to apple tree

=IF(A1<=3,REPT("๐ŸŒฑ",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐ŸŒฑ",3)&REPT("๐ŸŒณ",A1-3)&REPT("โ–‘",10-A1),REPT("๐ŸŒฑ",3)&REPT("๐ŸŒณ",3)&REPT("๐ŸŽ",A1-6)&REPT("โ–‘",10-A1)))

๐ŸŒฑ๐ŸŒฑ๐ŸŒฑ๐ŸŒณ๐ŸŒณ๐ŸŒณ๐ŸŽ๐ŸŽโ–‘โ–‘

IF REPT

Idea to rocket launch

=IF(A1<=5,REPT("๐Ÿ’ก",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ’ก",5)&REPT("๐Ÿš€",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ’ก๐Ÿ’ก๐Ÿ’ก๐Ÿ’ก๐Ÿ’ก๐Ÿš€๐Ÿš€๐Ÿš€โ–‘โ–‘

IF REPT

Pen to published book

=IF(A1<=5,REPT("๐Ÿ–Š๏ธ",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ–Š๏ธ",5)&REPT("๐Ÿ“–",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ–Š๏ธ๐Ÿ–Š๏ธ๐Ÿ–Š๏ธ๐Ÿ–Š๏ธ๐Ÿ–Š๏ธ๐Ÿ“–๐Ÿ“–๐Ÿ“–โ–‘โ–‘

IF REPT

Grapes to jam jar

=IF(A1<=5,REPT("๐Ÿ‡",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ‡",5)&REPT("๐Ÿซ™",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ‡๐Ÿ‡๐Ÿ‡๐Ÿ‡๐Ÿ‡๐Ÿซ™๐Ÿซ™๐Ÿซ™โ–‘โ–‘

IF REPT

Clay to pottery

=IF(A1<=4,REPT("๐ŸŸค",A1)&REPT("โ–‘",10-A1),IF(A1<=7,REPT("๐ŸŸค",4)&REPT("๐Ÿ”ฅ",A1-4)&REPT("โ–‘",10-A1),REPT("๐ŸŸค",4)&REPT("๐Ÿ”ฅ",3)&REPT("๐Ÿบ",A1-7)&REPT("โ–‘",10-A1)))

๐ŸŸค๐ŸŸค๐ŸŸค๐ŸŸค๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿบ๐Ÿบโ–‘

IF REPT

Paint to masterpiece

=IF(A1<=5,REPT("๐ŸŽจ",A1)&REPT("โ–‘",10-A1),REPT("๐ŸŽจ",5)&REPT("๐Ÿ–ผ๏ธ",A1-5)&REPT("โ–‘",10-A1))

๐ŸŽจ๐ŸŽจ๐ŸŽจ๐ŸŽจ๐ŸŽจ๐Ÿ–ผ๏ธ๐Ÿ–ผ๏ธ๐Ÿ–ผ๏ธโ–‘โ–‘

IF REPT

Homework to diploma

=IF(A1<=6,REPT("๐Ÿ“š",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ“š",6)&REPT("๐ŸŽ“",A1-6)&REPT("โ–‘",10-A1))

๐Ÿ“š๐Ÿ“š๐Ÿ“š๐Ÿ“š๐Ÿ“š๐Ÿ“š๐ŸŽ“๐ŸŽ“๐ŸŽ“โ–‘

IF REPT

Question to answer

=IF(A1<=5,REPT("โ“",A1)&REPT("โ–‘",10-A1),REPT("โ“",5)&REPT("โœ…",A1-5)&REPT("โ–‘",10-A1))

โ“โ“โ“โ“โ“โœ…โœ…โœ…โ–‘โ–‘

IF REPT

Maple sap to syrup

=IF(A1<=5,REPT("๐Ÿ",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ",5)&REPT("๐Ÿฏ",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ๐Ÿ๐Ÿ๐Ÿ๐Ÿ๐Ÿฏ๐Ÿฏ๐Ÿฏโ–‘โ–‘

IF REPT

Sunrise over horizon

=REPT("ยท",A1)&"๐ŸŒ…"&REPT("ยท",MAX(0,10-A1))

ยทยทยทยท๐ŸŒ…ยทยทยทยทยทยท

REPT MAX

Time of day sky

=REPT("ยท",A1)&IF(A1<=3,"๐ŸŒ…",IF(A1<=7,"โ˜€๏ธ","๐ŸŒ‡"))&REPT("ยท",MAX(0,10-A1))

ยทยทยทยทโ˜€๏ธยทยทยทยทยท

REPT MAX IF

Penguin march line

=REPT("๐Ÿง",A1)&REPT("ยท",MAX(0,6-A1))

๐Ÿง๐Ÿง๐Ÿงยทยทยท

REPT MAX

Car trip to mountain (arrow trail)

="๐Ÿ”๏ธ"&REPT("โ†",MAX(0,10-A1))&"๐Ÿš—"&REPT("ใƒป",MAX(0,A1-2))

๐Ÿ”๏ธโ†โ†โ†โ†โ†โ†๐Ÿš—ใƒปใƒป

REPT MAX

Car trip to McDonald's (arrow trail)

="๐ŸŸ"&REPT("โ†",MAX(0,10-A1))&"๐Ÿš—"&REPT("ใƒป",MAX(0,A1-2))

๐ŸŸโ†โ†โ†โ†โ†โ†๐Ÿš—ใƒปใƒป

REPT MAX

Burger run by car (arrow trail)

="๐Ÿ”"&REPT("โ†",MAX(0,10-A1))&"๐Ÿš—"&REPT("ใƒป",MAX(0,A1-2))

๐Ÿ”โ†โ†โ†โ†โ†โ†๐Ÿš—ใƒปใƒป

REPT MAX

Soda run to drink break (arrow trail)

="โ˜•"&REPT("โ†",MAX(0,10-A1))&"๐Ÿฅค"&REPT("ใƒป",MAX(0,A1-2))

โ˜•โ†โ†โ†โ†โ†โ†๐Ÿฅคใƒปใƒป

REPT MAX

Snack run to snack break (arrow trail)

="๐Ÿฟ"&REPT("โ†",MAX(0,10-A1))&"๐Ÿช"&REPT("ใƒป",MAX(0,A1-2))

๐Ÿฟโ†โ†โ†โ†โ†โ†๐Ÿชใƒปใƒป

REPT MAX

Snail race to finish (arrow trail)

=REPT("โ†",A1)&"๐ŸŒ"&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ"

โ†โ†โ†๐ŸŒใƒปใƒปใƒปใƒปใƒป๐Ÿ

REPT MAX

Rocket launch pad (arrow trail)

=REPT("โ†",MAX(0,8-A1))&"๐Ÿš€"&REPT(CHAR(9650),A1)

โ†โ†โ†โ†โ†๐Ÿš€โ–ฒโ–ฒโ–ฒ

REPT MAX CHAR

Pin map journey (arrow trail)

=REPT("โ†",A1)&"๐Ÿ“"&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ "

โ†โ†โ†๐Ÿ“ใƒปใƒปใƒปใƒป๐Ÿ 

REPT MAX

Ship sailing home (ripple trail)

=REPT("ใ€ฐ๏ธ",A1)&"โ›ต"&REPT("๐ŸŒŠ",MAX(0,8-A1))

ใ€ฐ๏ธใ€ฐ๏ธใ€ฐ๏ธโ›ต๐ŸŒŠ๐ŸŒŠ๐ŸŒŠ๐ŸŒŠ

REPT MAX

Sunrise over horizon (arrow trail)

=REPT("โ†",A1)&"๐ŸŒ…"&REPT("ใƒป",MAX(0,10-A1))

โ†โ†โ†โ†๐ŸŒ…ใƒปใƒปใƒปใƒปใƒป

REPT MAX

Time of day sky (arrow trail)

=REPT("โ†",A1)&IF(A1<=3,"๐ŸŒ…",IF(A1<=7,"โ˜€๏ธ","๐ŸŒ‡"))&REPT("ใƒป",MAX(0,10-A1))

โ†โ†โ†โ†โ˜€๏ธใƒปใƒปใƒปใƒปใƒป

REPT MAX IF

Penguin march line (arrow trail)

=REPT("๐Ÿง",A1)&REPT("โ†",MAX(0,6-A1))

๐Ÿง๐Ÿง๐Ÿงโ†โ†โ†

REPT MAX

Butterfly garden count

=REPT("๐Ÿฆ‹",A1)&REPT("๐ŸŒธ",5-A1)

๐Ÿฆ‹๐Ÿฆ‹๐Ÿฆ‹๐ŸŒธ๐ŸŒธ

REPT

X-wing Death Star trench run

=REPT("ใƒป",A1)&"๏ผž๐Ÿ›ธ๏ผœ"&REPT("ใƒป",MAX(0,10-A1))&"๐ŸŒ‘"

ใƒปใƒป๏ผž๐Ÿ›ธ๏ผœใƒปใƒปใƒปใƒป๐ŸŒ‘

REPT MAX

Millennium Falcon Kessel Run

=REPT("โœจ",A1)&"๐Ÿš€"&REPT("โœจ",MAX(0,10-A1))

โœจโœจโœจ๐Ÿš€โœจโœจโœจโœจโœจโœจ

REPT MAX

Hyperspace jump streak

=REPT("โœจ",A1)&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿš€"

โœจโœจโœจโœจใƒปใƒปใƒปใƒป๐Ÿš€

REPT MAX

Rescue Princess Leia

=REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ‘ธ"&REPT("ใƒป",A1)&"๐Ÿš€"

ใƒปใƒปใƒปใƒปใƒป๐Ÿ‘ธใƒปใƒปใƒป๐Ÿš€

REPT MAX

Escape from Hoth

=REPT("ใƒป",A1)&"๐Ÿš€"&REPT("ใƒป",MAX(0,10-A1))&"โ„๏ธ"

ใƒปใƒป๐Ÿš€ใƒปใƒปใƒปใƒปใƒปใƒปโ„๏ธ

REPT MAX

Tatooine desert crossing

=๐Ÿœ๏ธ&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿค–"&REPT("ใƒป",A1)&"โ˜€๏ธ"

๐Ÿœ๏ธใƒปใƒปใƒปใƒปใƒป๐Ÿค–ใƒปใƒปใƒปโ˜€๏ธ

REPT MAX

Podrace lap counter

=REPT("๐ŸŽ๏ธ",A1)&REPT("ใƒป",MAX(0,6-A1))&"๐Ÿ"

๐ŸŽ๏ธ๐ŸŽ๏ธ๐ŸŽ๏ธใƒปใƒปใƒป๐Ÿ

REPT MAX

Asteroid field dodge run

=REPT("โ˜„๏ธ",A1)&REPT("ใƒป",MAX(0,8-A1))&"๐Ÿš€"

โ˜„๏ธโ˜„๏ธโ˜„๏ธใƒปใƒปใƒป๐Ÿš€

REPT MAX

Hoth asteroid field density

=REPT("๐Ÿชจ",A1)&REPT("โ˜„๏ธ",MAX(0,5-A1))

๐Ÿชจ๐Ÿชจ๐Ÿชจโ˜„๏ธโ˜„๏ธ

REPT MAX

Falcon weaving through asteroids

=REPT("๐Ÿชจ",MAX(0,6-A1))&"๐Ÿš€"&REPT("๐Ÿชจ",A1)

๐Ÿชจ๐Ÿชจ๐Ÿชจ๐Ÿš€๐Ÿชจ๐Ÿชจ๐Ÿชจ

REPT MAX

Slave I asteroid pursuit

=REPT("๐Ÿชจ",A1)&"๐Ÿ›ธ"&REPT("ใƒป",MAX(0,8-A1))&"๐Ÿš€"

๐Ÿชจ๐Ÿชจ๐Ÿชจ๐Ÿ›ธใƒปใƒปใƒป๐Ÿš€

REPT MAX

Exogorth cave approach

=REPT("๐Ÿชจ",MAX(0,5-A1))&"๐Ÿ•ณ๏ธ"&REPT("๐Ÿ",A1)

๐Ÿชจ๐Ÿชจ๐Ÿ•ณ๏ธ๐Ÿ๐Ÿ๐Ÿ

REPT MAX

Comet tail flyby streak

=REPT("โ˜„๏ธ",A1)&REPT("โœจ",MAX(0,5-A1))&"๐Ÿš€"

โ˜„๏ธโ˜„๏ธโ˜„๏ธโœจโœจ๐Ÿš€

REPT MAX

Asteroid hideout stealth

=REPT("๐Ÿชจ",MAX(0,6-A1))&"๐Ÿš€"&REPT("๐Ÿชจ",A1)&"๐Ÿ‘€"

๐Ÿชจ๐Ÿชจ๐Ÿชจ๐Ÿš€๐Ÿชจ๐Ÿชจ๐Ÿ‘€

REPT MAX

Asteroid collision warning

=REPT("โš ๏ธ",A1)&REPT("โ˜„๏ธ",MAX(0,5-A1))

โš ๏ธโš ๏ธโš ๏ธโ˜„๏ธโ˜„๏ธ

REPT MAX

TIE fighters lost in asteroids

=REPT("๐Ÿ’ฅ",A1)&REPT("โ˜„๏ธ",MAX(0,5-A1))&" Imperial losses"

๐Ÿ’ฅ๐Ÿ’ฅ๐Ÿ’ฅโ˜„๏ธโ˜„๏ธ Imperial losses

REPT MAX

Asteroid belt traversal

=REPT("๐Ÿชจ",MAX(0,8-A1))&REPT("ใƒป",A1)&"โœ…"

๐Ÿชจ๐Ÿชจ๐Ÿชจ๐Ÿชจใƒปใƒปใƒปโœ…

REPT MAX

Comet dodge difficulty

=REPT("โ˜„๏ธ",A1)&REPT("โ—‹",5-A1)

โ˜„๏ธโ˜„๏ธโ˜„๏ธโ—‹โ—‹

REPT

Hyperspace blocked by asteroids

=IF(A1>0,"๐Ÿš€ Jump clear","โ˜„๏ธ Asteroids! Stay on sublights")

โ˜„๏ธ Asteroids! Stay on sublights

IF

Asteroid hull damage meter

=REPT("๐Ÿš€",1)&REPT("๐Ÿ’ฅ",A1)&REPT("โ—‹",5-A1)

๐Ÿš€๐Ÿ’ฅ๐Ÿ’ฅ๐Ÿ’ฅโ—‹โ—‹

REPT

Bounty hunter pursuit

=REPT("ใƒป",MAX(0,10-A1))&"๐ŸŽฏ"&REPT("ใƒป",A1)&"๐Ÿ’ฐ"

ใƒปใƒปใƒปใƒปใƒป๐ŸŽฏใƒปใƒปใƒป๐Ÿ’ฐ

REPT MAX

Sarlacc pit fall

=REPT("ใƒป",A1)&"๐Ÿ‘ค"&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ•ณ๏ธ"

ใƒปใƒป๐Ÿ‘คใƒปใƒปใƒปใƒปใƒปใƒป๐Ÿ•ณ๏ธ

REPT MAX

Death Star exhaust port shot

=REPT("ใƒป",MAX(0,10-A1))&"๐ŸŽฏ"&REPT("ใƒป",A1)&"๐Ÿ’ฅ"

ใƒปใƒปใƒปใƒปใƒป๐ŸŽฏใƒปใƒปใƒป๐Ÿ’ฅ

REPT MAX

AT-AT march on Hoth

=REPT("ใƒป",A1)&"๐Ÿค–"&REPT("ใƒป",MAX(0,10-A1))&"โ„๏ธ"

ใƒปใƒปใƒป๐Ÿค–ใƒปใƒปใƒปใƒปใƒปโ„๏ธ

REPT MAX

Endor shield generator raid

=REPT("๐ŸŒฒ",A1)&"๐Ÿ›ก๏ธ"&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ’ฅ"

๐ŸŒฒ๐ŸŒฒ๐ŸŒฒ๐Ÿ›ก๏ธใƒปใƒปใƒปใƒปใƒป๐Ÿ’ฅ

REPT MAX

Mustafar duel intensity

=REPT("๐Ÿ”ฅ",A1)&"โš”๏ธ"&REPT("๐Ÿ”ฅ",MAX(0,5-A1))

๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅโš”๏ธ๐Ÿ”ฅ๐Ÿ”ฅ

REPT MAX

Emperor force lightning

=REPT("โšก",A1)&REPT("โ—‹",5-A1)&" ๐Ÿ‘‘"

โšกโšกโšกโ—‹โ—‹ ๐Ÿ‘‘

REPT

Force power meter

=REPT("โœจ",A1)&REPT("โ—‹",5-A1)

โœจโœจโœจโ—‹โ—‹

REPT

Force lightning intensity

=REPT("โšก",A1)&REPT("โ—‹",5-A1)

โšกโšกโšกโ—‹โ—‹

REPT

Lightsaber training progress

=REPT("โš”๏ธ",A1)&REPT("โ—‹",5-A1)

โš”๏ธโš”๏ธโš”๏ธโ—‹โ—‹

REPT

Kyber crystal charge

=REPT("๐Ÿ’Ž",A1)&REPT("โ—‹",5-A1)

๐Ÿ’Ž๐Ÿ’Ž๐Ÿ’Žโ—‹โ—‹

REPT

Rebel alliance star rating

=REPT("โญ",A1)&REPT("โ˜†",5-A1)&" Rebel"

โญโญโญโ˜†โ˜† Rebel

REPT

Death Star construction progress

=REPT(CHAR(9608),A1)&REPT("โ–‘",10-A1)&" ๐ŸŒ‘"

โ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–‘โ–‘โ–‘โ–‘ ๐ŸŒ‘

REPT CHAR

Shield generator health

=REPT("โ–ˆ",A1)&REPT("โ–‘",10-A1)&" ๐Ÿ›ก๏ธ"

โ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–‘โ–‘โ–‘โ–‘ ๐Ÿ›ก๏ธ

REPT

Carbonite freezing progress

=REPT("โ–ˆ",A1)&REPT("โ–‘",10-A1)&" ๐ŸงŠ"

โ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–‘โ–‘โ–‘โ–‘ ๐ŸงŠ

REPT

Droid army counter

=REPT("๐Ÿค–",A1)&REPT("โ—‹",5-A1)

๐Ÿค–๐Ÿค–๐Ÿค–โ—‹โ—‹

REPT

Stormtrooper squad size

=REPT("๐Ÿช–",A1)&REPT("โ—‹",5-A1)

๐Ÿช–๐Ÿช–๐Ÿช–โ—‹โ—‹

REPT

Clone trooper battalion

=REPT("๐Ÿช–",A1)&" clones"

๐Ÿช–๐Ÿช–๐Ÿช– clones

REPT

TIE fighter formation

=REPT("๐Ÿ›ธ",A1)&REPT("ใƒป",MAX(0,6-A1))

๐Ÿ›ธ๐Ÿ›ธ๐Ÿ›ธใƒปใƒปใƒป

REPT MAX

Star Destroyer fleet count

=REPT("๐Ÿ›ธ",A1)&" Imperial fleet"

๐Ÿ›ธ๐Ÿ›ธ๐Ÿ›ธ Imperial fleet

REPT

Rebel starfighter squadron

=REPT("โญ",A1)&REPT("๐Ÿ›ธ",MIN(A1,3))

โญโญโญ๐Ÿ›ธ๐Ÿ›ธ๐Ÿ›ธ

REPT MIN

R2-D2 beep meter

=REPT("๐Ÿค–",1)&REPT("โ—",A1)&REPT("โ—‹",5-A1)

๐Ÿค–โ—โ—โ—โ—‹โ—‹

REPT

BB-8 roll distance

=REPT("๐Ÿค–",1)&REPT("โ—",A1)&REPT("โ—‹",MAX(0,10-A1))

๐Ÿค–โ—โ—โ—โ—โ—‹โ—‹โ—‹โ—‹โ—‹โ—‹

REPT MAX

C-3PO worry level

=REPT("๐Ÿค–",A1)&" Oh my!"

๐Ÿค–๐Ÿค–๐Ÿค– Oh my!

REPT

Porg infestation count

=REPT("๐Ÿฆ",A1)&" porgs"

๐Ÿฆ๐Ÿฆ๐Ÿฆ porgs

REPT

Baby Yoda soup rating

=REPT("๐Ÿฅฃ",1)&REPT("โญ",A1)&REPT("โ˜†",5-A1)

๐Ÿฅฃโญโญโญโ˜†โ˜†

REPT

Mandalorian beskar armor

=REPT("๐Ÿ›ก๏ธ",A1)&REPT("โ—‹",5-A1)

๐Ÿ›ก๏ธ๐Ÿ›ก๏ธ๐Ÿ›ก๏ธโ—‹โ—‹

REPT

Light side vs dark side meter

=REPT("๐Ÿ˜‡",A1)&REPT("๐Ÿ˜ˆ",5-A1)

๐Ÿ˜‡๐Ÿ˜‡๐Ÿ˜‡๐Ÿ˜ˆ๐Ÿ˜ˆ

REPT

Jedi or Sith alignment

=IF(A1="Jedi","๐Ÿ˜‡ Light side",IF(A1="Sith","๐Ÿ˜ˆ Dark side","โš– Neutral"))

๐Ÿ˜‡ Light side

IF

Lightsaber color picker

=CHOOSE(A1,"๐Ÿ”ต Blue","๐ŸŸข Green","๐Ÿ”ด Red","๐ŸŸฃ Purple","โšช White")

๐Ÿ”ต Blue

CHOOSE

Lightsaber duel winner

=IF(A1>5,"๐Ÿ˜‡ Jedi wins","๐Ÿ˜ˆ Sith wins")

๐Ÿ˜‡ Jedi wins

IF

Hyperdrive motivator status

=IF(A1>0,"๐Ÿš€ Hyperspace ready","โš ๏ธ Motivator shot")

๐Ÿš€ Hyperspace ready

IF

Tractor beam strength

=REPT("โ—Ž",A1)&REPT("โ—‹",5-A1)&" tractor beam"

โ—Žโ—Žโ—Žโ—‹โ—‹ tractor beam

REPT

Imperial loyalty meter

=REPT("๐Ÿ”ด",A1)&REPT("โšซ",5-A1)

๐Ÿ”ด๐Ÿ”ด๐Ÿ”ดโšซโšซ

REPT

Galactic Senate vote tally

=REPT("๐Ÿ‘",A1)&REPT("๐Ÿ‘Ž",MAX(0,10-A1))

๐Ÿ‘๐Ÿ‘๐Ÿ‘๐Ÿ‘๐Ÿ‘Ž๐Ÿ‘Ž๐Ÿ‘Ž๐Ÿ‘Ž๐Ÿ‘Ž๐Ÿ‘Ž

REPT MAX

Death Star plans recovered

=REPT("๐Ÿ“œ",A1)&REPT("โ—‹",3-A1)&" โ†’ ๐ŸŒ‘"

๐Ÿ“œ๐Ÿ“œ๐Ÿ“œ โ†’ ๐ŸŒ‘

REPT

Ewok victory celebration

=REPT("๐ŸŽ‰",A1)&REPT("๐ŸŒฒ",MAX(0,3-A1))

๐ŸŽ‰๐ŸŽ‰๐ŸŽ‰๐ŸŒฒ

REPT MAX

Vader force choke reach

=REPT("โœ‹",1)&REPT("ใƒป",A1)&"๐Ÿ’€"

โœ‹ใƒปใƒปใƒป๐Ÿ’€

REPT

Wookiee roar volume

=REPT("๐Ÿ”Š",A1)&REPT(CHAR(9601),MAX(0,5-A1))

๐Ÿ”Š๐Ÿ”Š๐Ÿ”Šโ–โ–

REPT MAX CHAR

Escape pod launch sequence

=REPT("ใƒป",MAX(0,10-A1))&"๐Ÿš€"&REPT("ใƒป",A1)&"๐Ÿช"

ใƒปใƒปใƒปใƒปใƒป๐Ÿš€ใƒปใƒปใƒป๐Ÿช

REPT MAX

Order 66 execution count

=REPT("โš”๏ธ",A1)&" executed"

โš”๏ธโš”๏ธโš”๏ธ executed

REPT

Yoda training patience

=REPT("โœจ",A1)&" ...patience you must have"

โœจโœจโœจ ...patience you must have

REPT

Han Solo parsecs brag

=A1&" parsecs"&REPT("๐Ÿš€",MIN(A1,3))

12 parsecs๐Ÿš€๐Ÿš€๐Ÿš€

REPT MIN

Imperial March footsteps

=REPT("๐Ÿฅพ",A1)&" dum dum dum dum"

๐Ÿฅพ๐Ÿฅพ๐Ÿฅพ dum dum dum dum

REPT

Jabba palace audience

=REPT("๐Ÿ’ฐ",A1)&" palace"

๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ’ฐ palace

REPT

Lightspeed skip damage risk

=REPT("โœจ",MOD(A1,5))&"๐Ÿš€"&REPT("๐Ÿ’ฅ",IF(A1>8,1,0))

โœจโœจ๐Ÿš€

REPT IF MOD

Luke watches the twin suns

=REPT("ใƒป",A1)&"๐Ÿง‘"&REPT("ใƒป",MAX(0,10-A1))&"โ˜€๏ธโ˜€๏ธ"

ใƒปใƒปใƒป๐Ÿง‘ใƒปใƒปใƒปใƒปใƒปใƒปโ˜€๏ธโ˜€๏ธ

REPT MAX

Obi-Wan vs Vader duel

=REPT("โš”๏ธ",A1)&REPT("โ—‹",5-A1)

โš”๏ธโš”๏ธโš”๏ธโ—‹โ—‹

REPT

Yoda lifting the X-Wing

=REPT("โœจ",A1)&"๐Ÿš€"

โœจโœจโœจ๐Ÿš€

REPT

Luke's trench approach

=REPT("โฌ›",A1)&"๐Ÿš€"&REPT("โฌ›",MAX(0,10-A1))&"๐ŸŽฏ"

โฌ›โฌ›โฌ›๐Ÿš€โฌ›โฌ›โฌ›โฌ›โฌ›โฌ›๐ŸŽฏ

REPT MAX

Death Star charging laser

=REPT("๐ŸŸข",A1)&REPT("โšช",5-A1)&" ๐ŸŒ‘"

๐ŸŸข๐ŸŸข๐ŸŸขโšชโšช ๐ŸŒ‘

REPT

TIE Fighter swarm

=REPT("๐Ÿ›ธ",A1)&" ๐Ÿš€"

๐Ÿ›ธ๐Ÿ›ธ๐Ÿ›ธ ๐Ÿš€

REPT

Rebel fleet assembling

=REPT("๐Ÿš€",A1)&REPT("โญ",MAX(0,5-A1))

๐Ÿš€๐Ÿš€๐Ÿš€โญโญ

REPT MAX

X-Wing attack run

=REPT("โญ",A1)&"๐Ÿš€"&REPT("ใƒป",MAX(0,10-A1))

โญโญโญ๐Ÿš€ใƒปใƒปใƒปใƒปใƒป

REPT MAX

Falcon escaping hyperspace

=REPT("โœจ",A1)&"๐Ÿš€๐Ÿ’จ"

โœจโœจโœจ๐Ÿš€๐Ÿ’จ

REPT

Droid factory conveyor

=REPT("โš™๏ธ",A1)&"๐Ÿค–"

โš™๏ธโš™๏ธโš™๏ธ๐Ÿค–

REPT

Clone army deployed

=REPT("๐Ÿช–",A1)&" Clone Army"

๐Ÿช–๐Ÿช–๐Ÿช– Clone Army

REPT

Jedi Council approval

=REPT("๐ŸŸข",A1)&REPT("โšช",5-A1)

๐ŸŸข๐ŸŸข๐ŸŸขโšชโšช

REPT

Sith influence meter

=REPT("๐Ÿ”ด",A1)&REPT("โšซ",5-A1)

๐Ÿ”ด๐Ÿ”ด๐Ÿ”ดโšซโšซ

REPT

Holocron unlocked

=REPT("๐Ÿ”ท",A1)&REPT("โฌœ",5-A1)

๐Ÿ”ท๐Ÿ”ท๐Ÿ”ทโฌœโฌœ

REPT

Kylo Ren rage level

=REPT("๐Ÿ’ข",A1)&REPT("โ—‹",5-A1)

๐Ÿ’ข๐Ÿ’ข๐Ÿ’ขโ—‹โ—‹

REPT

Darth Vader breathing

=REPT("๐Ÿ˜ฎโ€๐Ÿ’จ",A1)

๐Ÿ˜ฎโ€๐Ÿ’จ๐Ÿ˜ฎโ€๐Ÿ’จ๐Ÿ˜ฎโ€๐Ÿ’จ

REPT

Force ghost appearance

=REPT("๐Ÿ‘ป",A1)

๐Ÿ‘ป๐Ÿ‘ป

REPT

Ewok trap readiness

=REPT("๐Ÿชต",A1)&REPT("๐ŸŒฒ",5-A1)

๐Ÿชต๐Ÿชต๐Ÿชต๐ŸŒฒ๐ŸŒฒ

REPT

Speeder bike chase

=REPT("๐ŸŒฒ",A1)&"๐Ÿ๏ธ"

๐ŸŒฒ๐ŸŒฒ๐ŸŒฒ๐Ÿ๏ธ

REPT

Jabba's treasure pile

=REPT("๐Ÿ’ฐ",A1)&"๐ŸŒ"

๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ’ฐ๐ŸŒ

REPT

Carbonite thaw

=REPT("๐ŸงŠ",MAX(0,10-A1))&"๐Ÿ‘ค"

๐ŸงŠ๐ŸงŠ๐ŸงŠ๐ŸงŠ๐ŸงŠ๐ŸงŠ๐ŸงŠ๐Ÿ‘ค

REPT MAX

Sarlacc digestion

=REPT("๐Ÿฆท",A1)&"๐Ÿ•ณ๏ธ"

๐Ÿฆท๐Ÿฆท๐Ÿฆท๐Ÿ•ณ๏ธ

REPT

Boba Fett bounty tracker

=REPT("๐ŸŽฏ",A1)&"๐Ÿ’ฐ"

๐ŸŽฏ๐ŸŽฏ๐ŸŽฏ๐Ÿ’ฐ

REPT

Mandalorian bounty board

=REPT("๐Ÿ“œ",A1)&"๐Ÿช™"

๐Ÿ“œ๐Ÿ“œ๐Ÿ“œ๐Ÿช™

REPT

Grogu snack count

=REPT("๐Ÿฅš",A1)

๐Ÿฅš๐Ÿฅš๐Ÿฅš

REPT

Jawa scrap haul

=REPT("โš™๏ธ",A1)&"๐ŸคŽ"

โš™๏ธโš™๏ธโš™๏ธ๐ŸคŽ

REPT

Sandcrawler inventory

=REPT("๐Ÿ“ฆ",A1)&"๐Ÿšš"

๐Ÿ“ฆ๐Ÿ“ฆ๐Ÿ“ฆ๐Ÿšš

REPT

Blue milk rating

=REPT("๐Ÿฅ›",A1)&REPT("โ˜†",5-A1)

๐Ÿฅ›๐Ÿฅ›๐Ÿฅ›โ˜†โ˜†

REPT

Mos Eisley cantina crowd

=REPT("๐ŸŽบ",A1)&"๐Ÿบ"

๐ŸŽบ๐ŸŽบ๐ŸŽบ๐Ÿบ

REPT

Cantina band intensity

=REPT("๐ŸŽท",A1)&REPT("๐ŸŽบ",MAX(0,5-A1))

๐ŸŽท๐ŸŽท๐ŸŽท๐ŸŽบ๐ŸŽบ

REPT MAX

Force push distance

=REPT("ใ€ฐ๏ธ",A1)&"๐Ÿ‘ค"

ใ€ฐ๏ธใ€ฐ๏ธใ€ฐ๏ธ๐Ÿ‘ค

REPT

Jedi meditation

=REPT("๐Ÿง˜",A1)

๐Ÿง˜๐Ÿง˜๐Ÿง˜

REPT

Lightsaber crystal alignment

=CHOOSE(A1,"๐Ÿ”ต","๐ŸŸข","๐ŸŸฃ","๐ŸŸก","โšช","๐Ÿ”ด")

๐Ÿ”ต

CHOOSE

Bacta tank recovery

=REPT("๐Ÿ’™",A1)&REPT("๐Ÿค",5-A1)

๐Ÿ’™๐Ÿ’™๐Ÿ’™๐Ÿค๐Ÿค

REPT

Star Destroyer blockade

=REPT("๐Ÿ›ธ",A1)&"๐Ÿช"

๐Ÿ›ธ๐Ÿ›ธ๐Ÿ›ธ๐Ÿช

REPT

Shield generator charging

=REPT("๐Ÿ›ก๏ธ",A1)&REPT("โšก",MAX(0,5-A1))

๐Ÿ›ก๏ธ๐Ÿ›ก๏ธ๐Ÿ›ก๏ธโšกโšก

REPT MAX

Thermal detonator countdown

=10-A1&" ๐Ÿ’ฃ"

7 ๐Ÿ’ฃ

Holo-message transmission

=REPT("๐Ÿ“ก",A1)&"๐Ÿ‘ธ"

๐Ÿ“ก๐Ÿ“ก๐Ÿ“ก๐Ÿ‘ธ

REPT

Rebel transmission strength

=REPT("๐Ÿ“ถ",A1)

๐Ÿ“ถ๐Ÿ“ถ๐Ÿ“ถ

REPT

Imperial alert level

=CHOOSE(A1,"๐ŸŸข","๐ŸŸก","๐ŸŸ ","๐Ÿ”ด","๐Ÿšจ")

๐ŸŸ 

CHOOSE

Force balance

=REPT("โšช",A1)&"โš–๏ธ"&REPT("โšซ",10-A1)

โšชโšชโšชโš–๏ธโšซโšซโšซโšซโšซโšซโšซ

REPT

Binary sunset blinking

=IF(MOD(NOW()*86400,2)=0,"โ˜€๏ธโ˜€๏ธ","๐ŸŒ…")

โ˜€๏ธโ˜€๏ธ

IF MOD NOW

R2-D2 beeping

=CHOOSE(MOD(NOW()*86400,4)+1,"๐Ÿค–","๐Ÿค–๐Ÿ”ต","๐Ÿค–๐Ÿ”ด","๐Ÿค–๐ŸŸข")

๐Ÿค–๐Ÿ”ต

CHOOSE MOD NOW

Lightsaber flicker

=IF(MOD(NOW()*86400,2)=0,"โš”๏ธโœจ","โš”๏ธ")

โš”๏ธโœจ

IF MOD NOW

Death Star charging

=REPT("๐ŸŸข",MOD(NOW()*86400,6))&"๐ŸŒ‘"

๐ŸŸข๐ŸŸข๐ŸŸข๐ŸŒ‘

REPT MOD NOW

Hyperdrive charging

=REPT("โœจ",MOD(NOW()*86400,8))&"๐Ÿš€"

โœจโœจโœจโœจ๐Ÿš€

REPT MOD NOW

One Ring Mount Doom trek

=๐Ÿ”๏ธ&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ’"&REPT("ใƒป",A1)&"๐ŸŒ‹"

๐Ÿ”๏ธใƒปใƒปใƒปใƒปใƒป๐Ÿ’ใƒปใƒปใƒป๐ŸŒ‹

REPT MAX

Fellowship march to Mordor

=REPT("๐Ÿง",1)&REPT("๐Ÿง™",1)&REPT("๐Ÿง”",1)&REPT("ใƒป",MAX(0,10-A1))&REPT("๐Ÿ‘ฃ",A1)

๐Ÿง๐Ÿง™๐Ÿง”ใƒปใƒปใƒปใƒปใƒป๐Ÿ‘ฃ๐Ÿ‘ฃ๐Ÿ‘ฃ

REPT MAX

Gandalf vs Balrog bridge duel

=REPT("๐ŸŒ‰",1)&"๐Ÿง™"&REPT("๐Ÿ”ฅ",A1)&"๐Ÿ‘น"&REPT("๐Ÿ”ฅ",MAX(0,5-A1))

๐ŸŒ‰๐Ÿง™๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ‘น๐Ÿ”ฅ๐Ÿ”ฅ

REPT MAX

Helm's Deep battle line

=REPT("๐Ÿ›ก๏ธ",A1)&REPT("๐Ÿน",MAX(0,10-A1))&" ๐Ÿฐ"

๐Ÿ›ก๏ธ๐Ÿ›ก๏ธ๐Ÿ›ก๏ธ๐Ÿน๐Ÿน๐Ÿน๐Ÿน ๐Ÿฐ

REPT MAX

Rohan cavalry charge

=REPT("๐Ÿด",A1)&REPT("ใƒป",MAX(0,10-A1))&"โš”๏ธ"

๐Ÿด๐Ÿด๐Ÿดใƒปใƒปใƒปใƒปใƒปโš”๏ธ

REPT MAX

Orc army counter

=REPT("๐Ÿ‘น",A1)&REPT("โ—‹",5-A1)

๐Ÿ‘น๐Ÿ‘น๐Ÿ‘นโ—‹โ—‹

REPT

Uruk-hai squad size

=REPT("๐Ÿ‘น",A1)&" Uruk-hai"

๐Ÿ‘น๐Ÿ‘น๐Ÿ‘น Uruk-hai

REPT

Legolas arrow volley

=REPT("๐Ÿน",A1)&REPT("โ—‹",5-A1)

๐Ÿน๐Ÿน๐Ÿนโ—‹โ—‹

REPT

Gimli axe kill count

=REPT("๐Ÿช“",A1)&" dwarf kills"

๐Ÿช“๐Ÿช“๐Ÿช“ dwarf kills

REPT

Ent march on Isengard

=REPT("๐ŸŒณ",A1)&REPT("ใƒป",MAX(0,6-A1))&"๐Ÿฐ"

๐ŸŒณ๐ŸŒณ๐ŸŒณใƒปใƒปใƒป๐Ÿฐ

REPT MAX

Great Eagles rescue flight

=REPT("ใƒป",MAX(0,10-A1))&"๐Ÿฆ…"&REPT("ใƒป",A1)&"โ›ฐ๏ธ"

ใƒปใƒปใƒปใƒปใƒป๐Ÿฆ…ใƒปใƒปใƒปโ›ฐ๏ธ

REPT MAX

Sauron eye gaze intensity

=REPT("๐Ÿ‘๏ธ",A1)&REPT("โ—‹",5-A1)

๐Ÿ‘๏ธ๐Ÿ‘๏ธ๐Ÿ‘๏ธโ—‹โ—‹

REPT

Palantir vision meter

=REPT("๐Ÿ”ฎ",A1)&REPT("โ—‹",5-A1)

๐Ÿ”ฎ๐Ÿ”ฎ๐Ÿ”ฎโ—‹โ—‹

REPT

Mithril armor plates

=REPT("๐Ÿ›ก๏ธ",A1)&REPT("โ—‹",5-A1)&" mithril"

๐Ÿ›ก๏ธ๐Ÿ›ก๏ธ๐Ÿ›ก๏ธโ—‹โ—‹ mithril

REPT

Hobbit second breakfast count

=REPT("๐Ÿž",A1)&" breakfasts"

๐Ÿž๐Ÿž๐Ÿž breakfasts

REPT

Nazgul ringwraith pursuit

=REPT("ใƒป",A1)&"๐Ÿ‡"&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ’"

ใƒปใƒป๐Ÿ‡ใƒปใƒปใƒปใƒปใƒปใƒป๐Ÿ’

REPT MAX

Shelob web trap progress

=REPT("๐Ÿ•ธ๏ธ",A1)&REPT("ใƒป",MAX(0,8-A1))&"๐Ÿ•ท๏ธ"

๐Ÿ•ธ๏ธ๐Ÿ•ธ๏ธ๐Ÿ•ธ๏ธใƒปใƒปใƒป๐Ÿ•ท๏ธ

REPT MAX

Mines of Moria depth

=REPT("โ›๏ธ",A1)&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ’€"

โ›๏ธโ›๏ธโ›๏ธใƒปใƒปใƒปใƒปใƒป๐Ÿ’€

REPT MAX

Cave troll encounter

=REPT("๐Ÿ‘น",A1)&REPT("โ—‹",5-A1)&" troll"

๐Ÿ‘น๐Ÿ‘น๐Ÿ‘นโ—‹โ—‹ troll

REPT

Elven star light rating

=REPT("โœจ",A1)&REPT("โ˜†",5-A1)&" Elven"

โœจโœจโœจโ˜†โ˜† Elven

REPT

Knight vs dragon duel

=REPT("๐Ÿ›ก๏ธ",1)&REPT("โš”๏ธ",A1)&REPT("ใƒป",MAX(0,5-A1))&"๐Ÿ‰"

๐Ÿ›ก๏ธโš”๏ธโš”๏ธโš”๏ธใƒปใƒป๐Ÿ‰

REPT MAX

Dragon treasure hoard

=REPT("๐Ÿ’ฐ",A1)&REPT("๐Ÿ‰",1)

๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ‰

REPT

Dragon fire breath meter

=REPT("๐Ÿ”ฅ",A1)&REPT("โ—‹",5-A1)&"๐Ÿ‰"

๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅโ—‹โ—‹๐Ÿ‰

REPT

Sword fight intensity

=REPT("โš”๏ธ",A1)&REPT("โ—‹",5-A1)

โš”๏ธโš”๏ธโš”๏ธโ—‹โ—‹

REPT

Castle siege progress

=REPT("๐Ÿน",A1)&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿฐ"

๐Ÿน๐Ÿน๐Ÿนใƒปใƒปใƒปใƒปใƒป๐Ÿฐ

REPT MAX

Goblin ambush counter

=REPT("๐Ÿ‘บ",A1)&" goblins"

๐Ÿ‘บ๐Ÿ‘บ๐Ÿ‘บ goblins

REPT

Skeleton army march

=REPT("๐Ÿ’€",A1)&REPT("โ—‹",5-A1)

๐Ÿ’€๐Ÿ’€๐Ÿ’€โ—‹โ—‹

REPT

Troll bridge toll

=REPT("๐ŸŒ‰",1)&REPT("๐Ÿ‘น",A1)&" trolls"

๐ŸŒ‰๐Ÿ‘น๐Ÿ‘น๐Ÿ‘น trolls

REPT

Unicorn meadow count

=REPT("๐Ÿฆ„",A1)&REPT("๐ŸŒธ",5-A1)

๐Ÿฆ„๐Ÿฆ„๐Ÿฆ„๐ŸŒธ๐ŸŒธ

REPT

Griffin mountain flight

=REPT("๐Ÿฆ…",1)&REPT("ใƒป",A1)&"๐Ÿ”๏ธ"

๐Ÿฆ…ใƒปใƒปใƒป๐Ÿ”๏ธ

REPT

Phoenix rebirth flames

=REPT("๐Ÿ”ฅ",A1)&"๐Ÿฆ…"

๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿฆ…

REPT

Hydra head count

=REPT("๐Ÿ",A1)&" heads"

๐Ÿ๐Ÿ๐Ÿ heads

REPT

Werewolf moon howl

=REPT("๐Ÿบ",A1)&REPT("๐ŸŒ™",1)

๐Ÿบ๐Ÿบ๐Ÿบ๐ŸŒ™

REPT

Vampire bat swarm

=REPT("๐Ÿฆ‡",A1)&REPT("โ—‹",5-A1)

๐Ÿฆ‡๐Ÿฆ‡๐Ÿฆ‡โ—‹โ—‹

REPT

Medusa stone gaze

=REPT("๐Ÿ",A1)&"๐Ÿ‘๏ธ"&REPT("๐Ÿชจ",MAX(0,3-A1))

๐Ÿ๐Ÿ๐Ÿ‘๏ธ๐Ÿชจ

REPT MAX

Potion brewing progress

=REPT("๐Ÿงช",A1)&REPT(CHAR(9617),5-A1)&" ๐Ÿง™"

๐Ÿงช๐Ÿงช๐Ÿงชโ–’โ–’ ๐Ÿง™

REPT CHAR

Spell casting power

=REPT("โœจ",A1)&REPT("โ—‹",5-A1)&" mana"

โœจโœจโœจโ—‹โ—‹ mana

REPT

Dungeon crawl depth

=REPT("๐Ÿ•ฏ๏ธ",A1)&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ’€"

๐Ÿ•ฏ๏ธ๐Ÿ•ฏ๏ธ๐Ÿ•ฏ๏ธใƒปใƒปใƒปใƒปใƒป๐Ÿ’€

REPT MAX

Enchanted forest path

=REPT("๐ŸŒฒ",A1)&REPT("โœจ",MAX(0,5-A1))&"๐Ÿงš"

๐ŸŒฒ๐ŸŒฒ๐ŸŒฒโœจโœจ๐Ÿงš

REPT MAX

Wizard tower ascent

=REPT("ใƒป",MAX(0,10-A1))&"๐Ÿง™"&REPT("ใƒป",A1)&"๐Ÿ—ผ"

ใƒปใƒปใƒปใƒปใƒป๐Ÿง™ใƒปใƒปใƒป๐Ÿ—ผ

REPT MAX

Quest scroll tracker

=REPT("๐Ÿ“œ",A1)&REPT("โ—‹",3-A1)&" quests"

๐Ÿ“œ๐Ÿ“œ๐Ÿ“œ quests

REPT

Tavern ale rating

=REPT("๐Ÿบ",A1)&REPT("โญ",MIN(A1,5))

๐Ÿบ๐Ÿบ๐Ÿบโญโญโญ

REPT MIN

Treasure chest loot count

=REPT("๐Ÿ’Ž",A1)&REPT("๐Ÿ“ฆ",1)

๐Ÿ’Ž๐Ÿ’Ž๐Ÿ’Ž๐Ÿ“ฆ

REPT

Battle axe squad

=REPT("๐Ÿช“",A1)&REPT("โ—‹",5-A1)

๐Ÿช“๐Ÿช“๐Ÿช“โ—‹โ—‹

REPT

Shield wall formation

=REPT("๐Ÿ›ก๏ธ",A1)&REPT("โ—‹",5-A1)

๐Ÿ›ก๏ธ๐Ÿ›ก๏ธ๐Ÿ›ก๏ธโ—‹โ—‹

REPT

War camp fire intensity

=REPT("โ›บ",A1)&REPT("๐Ÿ”ฅ",MAX(0,5-A1))

โ›บโ›บโ›บ๐Ÿ”ฅ๐Ÿ”ฅ

REPT MAX

Elven vs orc battle meter

=REPT("๐Ÿง",A1)&REPT("๐Ÿ‘น",5-A1)

๐Ÿง๐Ÿง๐Ÿง๐Ÿ‘น๐Ÿ‘น

REPT

Hero or villain alignment

=IF(A1>3,"๐Ÿฆธ Hero","๐Ÿ‘น Villain")

๐Ÿฆธ Hero

IF

Fantasy weapon picker

=CHOOSE(A1,"โš”๏ธ Sword","๐Ÿน Bow","๐Ÿช“ Axe","๐Ÿ”ฎ Staff","๐Ÿ›ก๏ธ Shield")

โš”๏ธ Sword

CHOOSE

Dragon slayer victory

=IF(A1>5,"โš”๏ธ Dragon slain","๐Ÿ‰ Dragon wins")

โš”๏ธ Dragon slain

IF

Mermaid lagoon count

=REPT("๐Ÿงœ",A1)&REPT("๐ŸŒŠ",5-A1)

๐Ÿงœ๐Ÿงœ๐Ÿงœ๐ŸŒŠ๐ŸŒŠ

REPT

Kraken tentacle attack

=REPT("๐Ÿ™",A1)&REPT("๐ŸŒŠ",MAX(0,3-A1))

๐Ÿ™๐Ÿ™๐Ÿ™

REPT MAX

Cyclops boulder throw

=REPT("๐Ÿ‘๏ธ",1)&REPT("๐Ÿชจ",A1)&REPT("ใƒป",MAX(0,10-A1))&"๐ŸŽฏ"

๐Ÿ‘๏ธ๐Ÿชจ๐Ÿชจ๐Ÿชจใƒปใƒปใƒปใƒปใƒป๐ŸŽฏ

REPT MAX

Fairy dust sparkle trail

=REPT("๐Ÿงš",1)&REPT("โœจ",A1)&REPT("ใƒป",MAX(0,10-A1))

๐Ÿงšโœจโœจโœจโœจใƒปใƒปใƒปใƒปใƒป

REPT MAX

Excalibur drawn from the stone

=REPT("๐Ÿชจ",MAX(0,10-A1))&"โš”๏ธ"&REPT("โœจ",A1)

๐Ÿชจ๐Ÿชจ๐Ÿชจ๐Ÿชจโš”๏ธโœจโœจโœจโœจโœจโœจ

REPT MAX

King Arthur's round table

=REPT("๐Ÿ›ก๏ธ",A1)&" ๐Ÿฐ"

๐Ÿ›ก๏ธ๐Ÿ›ก๏ธ๐Ÿ›ก๏ธ๐Ÿ›ก๏ธ ๐Ÿฐ

REPT

Dwarf gold mine

=REPT("โ›๏ธ",A1)&REPT("๐Ÿ’ฐ",MAX(0,10-A1))

โ›๏ธโ›๏ธโ›๏ธ๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ’ฐ

REPT MAX

Magic portal opening

=REPT("๐ŸŒ€",A1)&REPT("โ—‹",5-A1)

๐ŸŒ€๐ŸŒ€๐ŸŒ€โ—‹โ—‹

REPT

Necromancer army raised

=REPT("๐Ÿ’€",A1)&REPT("โšฐ๏ธ",MAX(0,5-A1))

๐Ÿ’€๐Ÿ’€๐Ÿ’€โšฐ๏ธโšฐ๏ธ

REPT MAX

Dark tower corruption

=REPT("โšซ",A1)&REPT("โšช",5-A1)&" ๐Ÿฐ"

โšซโšซโšซโšชโšช ๐Ÿฐ

REPT

Wizard spellbook mastery

=REPT("๐Ÿ“–",A1)&REPT("โœจ",MAX(0,10-A1))

๐Ÿ“–๐Ÿ“–๐Ÿ“–โœจโœจโœจโœจโœจโœจโœจ

REPT MAX

Magic wand charge

=REPT("โœจ",A1)&REPT("โšช",5-A1)&"๐Ÿช„"

โœจโœจโœจโšชโšช๐Ÿช„

REPT

Crystal ball clarity

=REPT("๐Ÿ”ฎ",A1)&REPT("๐ŸŒซ๏ธ",5-A1)

๐Ÿ”ฎ๐Ÿ”ฎ๐Ÿ”ฎ๐ŸŒซ๏ธ๐ŸŒซ๏ธ

REPT

Treasure map completion

=REPT("๐Ÿ—บ๏ธ",A1)&REPT("โ“",5-A1)

๐Ÿ—บ๏ธ๐Ÿ—บ๏ธ๐Ÿ—บ๏ธโ“โ“

REPT

Dungeon boss approach

=REPT("๐Ÿšช",A1)&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ‘น"

๐Ÿšช๐Ÿšช๐Ÿšชใƒปใƒปใƒปใƒปใƒปใƒปใƒป๐Ÿ‘น

REPT MAX

Mimic suspicion level

=REPT("๐Ÿ“ฆ",A1)&REPT("๐Ÿ˜ˆ",MAX(0,5-A1))

๐Ÿ“ฆ๐Ÿ“ฆ๐Ÿ“ฆ๐Ÿ˜ˆ๐Ÿ˜ˆ

REPT MAX

Bard inspiration meter

=REPT("๐ŸŽต",A1)&REPT("โ—‹",5-A1)

๐ŸŽต๐ŸŽต๐ŸŽตโ—‹โ—‹

REPT

Tavern quest rumors

=REPT("๐Ÿบ",A1)&REPT("๐Ÿ“œ",MAX(0,5-A1))

๐Ÿบ๐Ÿบ๐Ÿบ๐Ÿ“œ๐Ÿ“œ

REPT MAX

Rogue stealth level

=REPT("๐Ÿ—ก๏ธ",A1)&REPT("๐ŸŒ‘",5-A1)

๐Ÿ—ก๏ธ๐Ÿ—ก๏ธ๐Ÿ—ก๏ธ๐ŸŒ‘๐ŸŒ‘

REPT

Ranger tracking progress

=REPT("๐Ÿ‘ฃ",A1)&REPT("๐ŸŒฒ",MAX(0,10-A1))

๐Ÿ‘ฃ๐Ÿ‘ฃ๐Ÿ‘ฃ๐ŸŒฒ๐ŸŒฒ๐ŸŒฒ๐ŸŒฒ๐ŸŒฒ๐ŸŒฒ๐ŸŒฒ

REPT MAX

Enchanted sword power

=REPT("โš”๏ธ",A1)&REPT("โœจ",MAX(0,5-A1))

โš”๏ธโš”๏ธโš”๏ธโœจโœจ

REPT MAX

Dungeon key collection

=REPT("๐Ÿ—๏ธ",A1)&REPT("๐Ÿšช",MAX(0,5-A1))

๐Ÿ—๏ธ๐Ÿ—๏ธ๐Ÿ—๏ธ๐Ÿšช๐Ÿšช

REPT MAX

Dragon egg hatch progress

=REPT("๐Ÿฅš",MAX(0,10-A1))&"๐Ÿฃ"&REPT("๐Ÿ”ฅ",A1)

๐Ÿฅš๐Ÿฅš๐Ÿฅš๐Ÿฅš๐Ÿฃ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ

REPT MAX

Pegasus flight distance

=REPT("โ˜๏ธ",A1)&"๐Ÿฆ„"&REPT("โ˜๏ธ",MAX(0,10-A1))

โ˜๏ธโ˜๏ธโ˜๏ธ๐Ÿฆ„โ˜๏ธโ˜๏ธโ˜๏ธโ˜๏ธโ˜๏ธโ˜๏ธโ˜๏ธ

REPT MAX

Treasure chest lockpick

=REPT("๐Ÿ—๏ธ",A1)&REPT("๐Ÿ”’",5-A1)

๐Ÿ—๏ธ๐Ÿ—๏ธ๐Ÿ—๏ธ๐Ÿ”’๐Ÿ”’

REPT

Dungeon torch supply

=REPT("๐Ÿ”ฅ",A1)&REPT("๐Ÿ•ฏ๏ธ",5-A1)

๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ•ฏ๏ธ๐Ÿ•ฏ๏ธ

REPT

Magic academy grades

=CHOOSE(A1,"๐Ÿงน Apprentice","๐Ÿ“– Student","๐Ÿช„ Mage","๐Ÿ”ฎ Wizard","๐Ÿง™ Archmage")

๐Ÿง™ Archmage

CHOOSE

Alignment meter

=REPT("๐Ÿ˜‡",A1)&REPT("๐Ÿ˜ˆ",5-A1)

๐Ÿ˜‡๐Ÿ˜‡๐Ÿ˜‡๐Ÿ˜ˆ๐Ÿ˜ˆ

REPT

Quest completion tracker

=REPT("โœ…",A1)&REPT("๐Ÿ“œ",MAX(0,10-A1))

โœ…โœ…โœ…๐Ÿ“œ๐Ÿ“œ๐Ÿ“œ๐Ÿ“œ๐Ÿ“œ๐Ÿ“œ๐Ÿ“œ

REPT MAX

Loot rarity picker

=CHOOSE(A1,"โšช Common","๐ŸŸข Uncommon","๐Ÿ”ต Rare","๐ŸŸฃ Epic","๐ŸŸ  Legendary")

๐ŸŸฃ Epic

CHOOSE

Boss battle health bar

=REPT("โค๏ธ",A1)&REPT("๐Ÿ–ค",10-A1)&" ๐Ÿ‘น"

โค๏ธโค๏ธโค๏ธโค๏ธ๐Ÿ–ค๐Ÿ–ค๐Ÿ–ค๐Ÿ–ค๐Ÿ–ค๐Ÿ–ค ๐Ÿ‘น

REPT

Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons