# Excel Formula (MIN or MAX) is not working **URL:** https://community.glideapps.com/t/excel-formula-min-or-max-is-not-working/80857 **Category:** Ask for Help **Tags:** excel **Created:** [March 20, 2025, 4:22am UTC](https://community.glideapps.com/t/excel-formula-min-or-max-is-not-working/80857 "2025-03-20T04:22:00Z") **Posts on this page:** 8 **Page:** 1
### Author: ![Deny\_Pratama](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deny_pratama/32/61099_2.png) [@Deny\_Pratama](https://community.glideapps.com/u/Deny_Pratama) #### Post date: [March 20, 2025, 4:22am UTC](https://community.glideapps.com/t/excel-formula-min-or-max-is-not-working/80857/1 "2025-03-20T04:22:00Z")
Hello Experts I want to implement Excel Formula Fuction that is Minimum from a set of columns. When I implement another formula such as SUM or AVERAGE, that’s works perfectly. But if i change the formula to MIN or MAX, it won’t show any result. Here are some pics to be clear. Appreciate for your guidance! SUM formula works fine: ![Screenshot 2025-03-20 at 12.06.29](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/a/da0e08436d967019e0f1a096bb3662add5dca68c.png) While MIN formula isn’t showing anything : ![Screenshot 2025-03-20 at 12.05.52](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/5/758f831b589db07cadeb4785f4b7cbd7a7eaacfd.png) ---
### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy) #### Post date: [March 20, 2025, 5:58am UTC](https://community.glideapps.com/t/excel-formula-min-or-max-is-not-working/80857/2 "2025-03-20T05:58:24Z")
I never use the Excel column, but I can suggest a workaround. Use a Make Array column to create an array from the 3 columns, then target that with a Rollup-\>Minimum. ---
### Author: ![Deny\_Pratama](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deny_pratama/32/61099_2.png) [@Deny\_Pratama](https://community.glideapps.com/u/Deny_Pratama) #### Post date: [March 20, 2025, 6:38am UTC](https://community.glideapps.com/t/excel-formula-min-or-max-is-not-working/80857/3 "2025-03-20T06:38:31Z")
Thank you, Darren for your suggestion. That’s work! ![Screenshot 2025-03-20 at 14.35.28](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/b/9b042fc8b6139f85074a479049bede21dd059a15.png) And not all Excel formula works in Excel Formula column that Glide provide. Now I can move on. Thanks a lot! ---
### Author: ![Deny\_Pratama](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deny_pratama/32/61099_2.png) [@Deny\_Pratama](https://community.glideapps.com/u/Deny_Pratama) #### Post date: [March 20, 2025, 10:16pm UTC](https://community.glideapps.com/t/excel-formula-min-or-max-is-not-working/80857/4 "2025-03-20T22:16:09Z")
Darren, one more issue about the RollUp. I think one of my column not detecting the number, so that Minimum function is not showing up. ![Screenshot 2025-03-21 at 06.01.05](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/4/74acad5755b22dae3a4953c8731593a799b4726d.png) I assume that because the text: 15 10 12 that I split from a Choice, is not recognized as a number. So I tried to convert it as a number with simple Math column, then Make Array, and RollUp. But the Minimum function still doesn’t work. ![Screenshot 2025-03-21 at 06.00.34](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/4/c4925f0e896c07e363413056d4c216f25ec19bc5.png) I need your enlightment once again. Thank you. ---
### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager) #### Post date: [March 20, 2025, 11:47pm UTC](https://community.glideapps.com/t/excel-formula-min-or-max-is-not-working/80857/5 "2025-03-20T23:47:53Z")
You could just use a math column for all of this and skip creating the array. For Min, you could do something like this. `min(min(x,y),z)` ---
### Author: ![Deny\_Pratama](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deny_pratama/32/61099_2.png) [@Deny\_Pratama](https://community.glideapps.com/u/Deny_Pratama) #### Post date: [March 21, 2025, 4:12am UTC](https://community.glideapps.com/t/excel-formula-min-or-max-is-not-working/80857/6 "2025-03-21T04:12:27Z")
Oh Jeff, I’ve tried it at the Math Column. And that’s works with the Minimum fuction. Thanks! ---
### Author: ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb) #### Post date: [March 21, 2025, 9:18am UTC](https://community.glideapps.com/t/excel-formula-min-or-max-is-not-working/80857/7 "2025-03-21T09:18:53Z")
Hehe that’s smart 😅 ---
### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system) #### Post date: [March 28, 2025, 9:19am UTC](https://community.glideapps.com/t/excel-formula-min-or-max-is-not-working/80857/8 "2025-03-28T09:19:19Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.