Life & fun · February 19, 2022
Simple method to create complex Excel formulas
If I have trouble visualizing an excel formula in one cell on the fly, I use a trick to make it easier. Let's say I have the following cells | A | B | C | 1|mary| |Jane| In D1 I want to concatenate the cell values if the cell contains text. First I make a formula to check if the cell contains text somewhere in a cell on the sheet. Let us go with A6. A6: =ISTEXT(A1) result=TRUE ; Hooray! Then, if A6 is true, I want to display the text from A1 because I cannot concatenate "true" as I will be doing later on: A7: =IF(A6=true,A1,"") result=mary ; Yippy! I do the same thing for each cell: A8:…
Simple method to create complex Excel formulas launched on February 19, 2022 with 14 votes, #1,012 of 2,645 launches that month and more than 75% of that year's launches.
In plain words
This is a technique for breaking down complex Excel formulas into simpler, manageable steps. Users build formulas piece by piece using helper cells to test conditions and extract values before combining them into a final result. It is for anyone who finds it difficult to construct multi-step formulas all at once. The approach helps visualize each part of the logic separately, making it easier to debug and verify results before concatenating or combining them.
written from the facts on this page · September 2026
From the sources
In the maker’s words, at launch
If I have trouble visualizing an excel formula in one cell on the fly, I use a trick to make it easier. Let's say I have the following cells | A | B | C | 1|mary| |Jane| In D1 I want to concatenate the cell values if the cell contains text. First I make a formula to check if the cell contains text somewhere in a cell…
Does a similar job
all alternatives →
Excelformulabot.com2022 · betteranalyst.com · ▲151Turn your text instructions into an Excel formula via AI
- FAFrockly – A visual editor for understanding complex Excel formulasDec 2025 · ▲56
I built a visual editor that represents Excel formulas as blocks, making it easier to inspect, refactor, and reason about complex formulas structurally. Frockly is not an Excel replacement. It focuses on understanding and refactoring formulas before bringing them back to Excel. Demo: https://ryuu12358.github.io/Frockly/ GitHub: https://github.com/ryuu12358/Frockly Write-up: https://note.com/ryuu12358/n/naa65d9d5facd （Japanese）
More life & fun this month
the category →
A free city-building game in your browser. You are the mayor. You know what the city needs. Now get it past the zoning board, the neighbors, the appeals court and the next election.
Life & fun · 2d ago · permit.petercai.com
- IV
Life & fun · 14d ago · tanzaniaeducationproject.org
Turn a phone, tablet or TV into a sign. Type a message and it fills the screen: welcome signs, timers, Wi-Fi passwords and more. No app, no account, free.
Life & fun · 15d ago · bigwords.page
Play a free virtual guitar online with your keyboard or by touch. Slow songs down and see every chord, string and strum. Acoustic, classic, electric and bass.
Life & fun · 9d ago · guitoro.com
Carrier settings from iPhone, Pixel and Galaxy firmware, decoded and compared: APNs, VoLTE, 5G and Wi-Fi Calling per carrier, and what each build changed.
Life & fun · 13d ago · carrierexplode.com
Life & fun · 23d ago · space.bl2.net
Source: Show HN post ↗ · launch text quoted in part
Launched alongside, February 2022
the whole month →
Sha256 algorithm explained online step by step visually
Life & fun · 2022 · sha256algorithm.com
EdgeDB 1.0▲947Today, after years of research, development, and refinement EdgeDB graduates to a production-ready database. We are very proud to announce EdgeDB 1.0.
Dev tools · 2022 · edgedb.com
