User Profile
ESAM_HASHIM
Brass Contributor
Joined Feb 03, 2018
User Widgets
Recent Discussions
Re: Lowest Common Multiple
Thank you SnowMan55 very much for this significant effort that is clear in the details of the example presented by you, which I can consider to be one of the important sources in everything related to finding the least common multiple of a large set of integers. Kindly Regards946Views0likes1CommentRe: Lowest Common Multiple
m_tarler Honestly, I don't post anything I'm not sure about I am very grateful for your great efforts that resulted in providing Excel users with a wide range of options to choose the appropriate formula to find the least common multiple. Best regards2.8KViews0likes4CommentsRe: Lowest Common Multiple
Hello m_tarler Thank you so much for your last post In fact, this post was pretty impressive, which resulted in creating the following two formulas =REDUCE(1;A1:A100;LAMBDA(p;q;IFERROR(p*q/GCD(p;q);p))) =LCM_prime(A1:A100) If I were asked which is better, I would answer that the second formula is the best and most comprehensive to be added to the most familiar formula to find LCM number for different situations with respect to reasons stated in Sheet3 Kindly Regards2.9KViews0likes6CommentsRe: Lowest Common Multiple
Hello SergeiBaklan 1. Actually I opened all your links by my mobile device before I discover a fact (Through Chat season with Norton support) that I must turn on VPN feature in my Windows PC 2. Thank you to provide me the article shown in your link that I will keep it as a great reference for any thing related to LCM formula's in Excel Best regards3KViews0likes0CommentsLowest Common Multiple
It is often very easy to apply the familiar FORMULA (=LCM(A1:A100)to find Lowest Common Multiple for a long wide numbers that included in a column as shown in sheet1 But sometimes I find it's so difficult to apply the above formula to another numbers as shown in sheet2 So I ask about the best formula for such instance that shown in sheet2Solved5.4KViews0likes23CommentsRe: How to split cell containing FRACTION into two cells including Numerator and denominator
Thank you Riny_van_Eekelen so much for your generosity Please let me to explain the steps that applied by going to My_Worksheet file 1. Firstly, I pasted the Column A from another worksheets after changing the format cell to view fractions 2. I got the values shown in B column by 2 equations shown in the file 3. I have repeated values shown in column E MANUALLY from B column to be able to apply the two formulas in columns F & G My question was are there another way rather than repeat values manually in column E to be able to split all cells as shown in columns F & G16KViews0likes6CommentsRe: How to split cell containing FRACTION into two cells including Numerator and denominator
PeterBartholomew1 Thank you for your trial to help me but I would like to inform you that the formula provided by Detlef_Lewin is the most practical for my situation I try to apply your formulas in My_Worksheet file but without any positive results, that's may be due to I am not expert in using those formulas you used in your example (fractions.xlsx) Kind Regards17KViews0likes2CommentsEvaluate the Least Common Multiple in fractions in Excel
Hi to all I am the first time inter this website In the following spread sheet, the first row (Red numbers) includes the denominators of multiple fractions such as 1/12, 1/36, 1/60, 1/72 and else were As shown in this sheet I get from multiple calculations the specified value in S16 cell (19,958,400) that can be divided on each number in first row without decimal value My question is are there a formula that can be applied to get the greatest value shown in S16 without multiple calculations Kind Regards NOTE: The original spread sheet is in the following link https://onedrive.live.com/edit.aspx?resid=AC822C5DC82A8A59!71228&ithint=file%2cxlsx&authkey=!AKM4qAjt5qbCgY01.1KViews0likes1CommentRe: How to split cell containing FRACTION into two cells including Numerator and denominator
Please can you tell me how to PASTE SPECIAL as text to make the formula possible, because I didn't find any way rather than inter all required fractions MANUALLY to apply the specified formulas, you can copy the example sheet to a new sheet to be more understand your idea Much apricated.16KViews0likes8CommentsRe: How to split cell containing FRACTION into two cells including Numerator and denominator
Thank you very much Riny_van_Eekelen I can conclude from your file the following critical points to apply the two formula correctly as shown by replied file that attached here: 1, The first step is to change Format Cells in all empty cells to be Text format 2. Then I must inter all required fractions MANUALLY because (as concluded) Excel cannot accept all options in copy pest at all From all above points please, I need to verify my idea Warm Regards17KViews0likes10CommentsHow to split cell containing FRACTION into two cells including Numerator and denominator
Hi everyone here If I have 4 cells containing the following fractions as example, my question is about the formula that can be applied for each for these cells to get two cells including Numerator and denominator for each fraction? 1/80 2/195 7/3744 7/8 Kind regardsSolved19KViews0likes21Comments
Recent Blog Articles
No content to show