You are here: PSPad forum > English discussion forum > calculations in Excel

calculations in Excel

#1 calculations in Excel

Posted by: maki | Date: 2020-06-24 12:23 | IP: IP Logged

Could someone do calculations in Excel.
I have 10,000 numbers and I want the result as a multiplication.

A. Last two numbers
B. 10000 TO 20000

Example:

10001 = 0
10002 = 0
10003 = 0
10004 = 0
....
11123 = 2x3 = 06
12345 = 4x5 = 20
12346 = 4x6 = 24
12347 = 4x7 = 28

14567 = 6x7= 42
...
20000

Edited 2 time(s). Last edit at 2020-06-24 12:24 by maki.

Options: Reply | Quote | Up ^


#2 Re: calculations in Excel

Posted by: pspad | Date: 2020-06-24 14:55 | IP: IP Logged

If your numbers are in A1, use this formula:
=QUOTIENT(MOD(A1;100); 10)*MOD(A1;10)
If not, replace A1 with something real.
Copy this formula to B1, mark all column along filled in A values and pres Ctrl+D

Edited 1 time(s). Last edit at 2020-06-24 14:55 by pspad.

Options: Reply | Quote | Up ^


#3 Re: calculations in Excel

Posted by: maki | Date: 2020-06-24 17:20 | IP: IP Logged

Sorry, I don't use Excel because it's paid, but a similar tool.
It's a different here ...

www.softpedia.com

where is A1?
WHERE IS B1 WHERE TO ENTER THIS FORMULA?

Edited 1 time(s). Last edit at 2020-06-24 17:25 by maki.

Options: Reply | Quote | Up ^


#4 Re: calculations in Excel

Posted by: pspad | Date: 2020-06-24 17:32 | IP: IP Logged

You asked Excel. You got answer for excel, even it isn't related to PSPad. Marked as solved.

Options: Reply | Quote | Up ^


This Thread has been closed





Editor PSPad - freeware editor, © 2001 - 2020 Jan Fiala, Hosted by Webhosting TOJEONO.CZ, design by WebDesign PAY & SOFT, code Petr Dvořák, Privacy policy and GDPR