User Profile
SergeiBaklan
Diamond Contributor
Joined Jul 15, 2016
User Widgets
Recent Discussions
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" )Re: Python in Excel
Python in Excel is built-in functionality ( not plugin). Thus you have it or you don't have it, there is no way to install it additionally. Please check previous discussion to see on which Excel python is available. Yes, it is Python in Excel add-on which works on the top of built-in functionality adding premium features to basic python in Excel. It's paid option and it works in same environment where basic python in excel exists.Re: Python in Excel
NikolinoDE , not exactly. Python in Excel available in Excel for Web available for Enterprise and Business users both on Windows and Web (not sure about Mac), I guess on all channels starting from semi-annual moreover, it's available on consumer subscriptions At least I could confirm that have it on Family subscription. More details are here Python in Excel availability - Microsoft SupportRe: Pivot Table: Grouping doesn't work (tried almost everything)
Most often that happens if you have texts which looks like dates or numbers. "formated everything consistently (no text, only numbers..." won't help. If you apply, for example, date format to text like "07/01/2026" it still will be text, not actual date. How exactly did you veryfy if there is text or blank space instead of numbers? Checked cell by cell with ISNUMBER or ISTEXT; or transform possible texts to numbers with Text to Columns; or checked values alignment visually; or something else?Re: Gantt Chart Weekday Function
Depends on logic. If duration 1 day always means next workday after the first worday (e.g. start is sat, first workday is Mon, duration =1, end = Tue which is Mon+1); 0 means start and end at first worday (e.g. for above is Mon), we may use =($D9<=H$5) * (WORKDAY($D9-1, $C9)>=WORKDAY(H$5,-1) )
