Need an Excel formula

Reply #7

Murgatroyd — Fri, 27 Mar 2015 00:46:13 GMT

Try MOD(a1-111, 1000)

(If you want to subtract from a number in a cell other than a1, adjust accordingly.

Reply #6

SergeM — Wed, 18 Mar 2015 16:43:59 GMT

He eventually has seen my reaction on a thread of Pick 3 on Lotterypost.

I solve the problem with one single custom function.

The problem can be solved with Excel functions too, you don't need to program. A Google spreadsheet probably does it too, just like other Excel like programs.

I give a lot of credit to pen and pencil, as I never forget that couple.

Reply #5

RJOh — Wed, 18 Mar 2015 14:37:33 GMT

If you can do it with paper and pencil, why do you need Excel

Reply #4

SergeM — Tue, 17 Mar 2015 22:20:08 GMT

Remarkable long piece of coding. You have Excel tradition.

Reply #3

winsumloosesum — Tue, 10 Mar 2015 13:28:34 GMT

https://app.box.com/s/0b2nwsolmi28cjlwloukkm7nxenk2adp

Reply #2

SkyLine69 — Wed, 04 Mar 2015 23:26:21 GMT

Did this answer your excel needs? If not, let me know and I'll write the formula perhaps differently but looks like Phil did great

Reply #1

phileight — Wed, 04 Mar 2015 00:20:05 GMT

I am not very good with if statements in excel so I will do this in two steps

assumption your result is in row C as in a1=106 b1=111 c1=a1-b1

step 1: you first result ( a negative # in this case is in cell c1)

step 2 in D1 enter =IF(C1 0,(1000+C1),C1) now you will have the positive number you are seeking. hide col C or ignore it

change cell references as needed

copy down as needed

Need an Excel formula

Rakster — Tue, 03 Mar 2015 03:21:37 GMT

I want to minus -111 from a number but I want to show a positive number that would be a 3 digit number.

Can anyone do this in Excel

for example...

439

328

217

106

-005

-116

-227

-338

as you can see 106 minus -111 should be 995 not -005

it then screws up everything after... can someone please formulate this for excel for me please.

thank you