User Profile
SergeiBaklan
Diamond Contributor
Joined Jul 15, 2016
User Widgets
Recent Discussions
Re: Python in Excel - Missing from desktop Excel but exist in web Excel
At least one thing is wrong - you are to be on Current (Preview), not on Current. You may check build numbers for each channel here Release notes for Current Channel (Preview) releases - Office release notes | Microsoft Learn You may deploy proper channel using Office Deployment Tool or by other way, details shall be on Insider site. Not sure how to do that exactly for consumer or educational subscriptions.Re: Looking for help with a single Dynamic Formula Ranking Points by player and dropping lowest score
Practically the same as Olufemi7 suggested =SORT( HSTACK( REGEXEXTRACT(NameFinishes, "\w*",1), MAP( NameFinishes, LAMBDA(v, SUM( CHOOSEROWS( Points, DROP( SORT( --REGEXEXTRACT(v, "\d+",1),,,1 ),,-1) ) ) )) ), 2,-1)Re: Excel giving incorrect answer to simple multiplication
Excel uses double precision floating point calculations (numbers from 10^-308 to 10^308) with 15-17 decimal digits precision to show result of calculation. With A2 formula =A1*2, etc. Excel doesn't take result from previous cell, it builds calculation chain. Result of calculation in each row is exactly the same as we use formula like =$A$1*2^(ROW()-1). Practically no cumulative error. Another story in each cell Excel shows 15 significant digits using first 17 for rounding to them. With using =ROUND(2*A1,2) starting from some point we collect an error and result will be less accurate compare to previous formulae. We may check above using any more or less modern scientific calculatorRe: Trying to fill a field in excel with 3 different wordfs based on another field result
Other variants =LOOKUP(G7, {0, 0.33, 0.75}, {"Bad", "Fair", "Good"} ) & " Deal" =IF( G7 >= 0.75, "Good Deal", IF(G7 >= 0.33, "Fair Deal", "Bad Deal") ) =SWITCH( TRUE, G7 >=0.75, "Good Deal", G7 >=0.33, "Fair Deal", G7 >=0, "Bad Deal" )
