Multiplication of all numbers in a cell by a specific number

0 votes

I have a minor issue. I want to multiply all the numbers in a cell starting on a new line by 1.8, but I am sadly starting to get confused. I tried splitting and combining with an array, but I ultimately failed.

enter image description here

Feb 21, 2023 in Others by Kithuzzz
 • 38,010 points • 215 views

1 answer to this question.

0 votes

With ms365, try:

enter image description here

The formula in B1:

=MAP(A1:A3,LAMBDA(x,TEXTJOIN(CHAR(10),,TEXTSPLIT(x,CHAR(10))*1,8)))
answered Feb 21, 2023 by narikkadan
 • 63,420 points

Related Questions In Others

0 votes
1 answer

Calculate the number of days between a cell and today in excel?

Use the DATEDIF function when you want ...READ MORE

answered Nov 8, 2022 in Others by gaurav
 • 23,260 points • 435 views
0 votes
1 answer

Generate a flat list of all excel cell formulas

Hello, you'll have to follow certain steps ...READ MORE

answered Feb 18, 2022 in Others by gaurav
 • 23,260 points • 370 views
0 votes
1 answer

Ordering by the order of values in a SQL IN() clause

We can use expressions as well in ...READ MORE

answered May 31, 2022 in Others by Sohail
 • 3,040 points • 276 views
0 votes
1 answer

Ordering by the order of values in a SQL IN() clause

Use MySQL FIND_IN_SET function: SELECT * ...READ MORE

answered Jun 6, 2022 in Others by nisha
 • 2,210 points • 482 views
0 votes
1 answer

How can I import an Excel file into SQL Server?

You can use OPENROWSET to import an Excel file ...READ MORE

answered Sep 15, 2022 in Database by narikkadan
 • 63,420 points • 1,621 views
0 votes
1 answer

Convert Excel sheet having shivaji fonts to csv having google unicode utf-8 encoding

I take it that you mean "Shivaji ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
 • 63,420 points • 789 views
0 votes
1 answer

Thousand and million formatting for negative numbers (excel/ googlesheets)

Its not possible. What you could do is ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
 • 63,420 points • 923 views
0 votes
1 answer

Convert csv- or Excel-file (xlsx) to kml with custom markers

With some help from the community, I ...READ MORE

answered Sep 26, 2022 in Others by narikkadan
 • 63,420 points • 885 views
0 votes
1 answer

How to stick an embedded document in a specific cell of an excel

Solution Select the documents (you can use the ...READ MORE

answered Oct 18, 2022 in Others by narikkadan
 • 63,420 points • 434 views
0 votes
1 answer

Python/Openpyxl: change cell A1 in all excel worksheets within a workbook to equal the name of the worksheet tab

You made a mistake when you used ...READ MORE

answered Nov 17, 2022 in Others by narikkadan
 • 63,420 points • 992 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.