You are here: PSPad forum > English discussion forum > Re: 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.

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.

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 ...

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.

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.

This Thread has been closed

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