Please help with simple Excel formula

Reply #5

calabs — Fri, 24 Feb 2006 03:31:23 GMT

Thanks hypersoniq - that did the trick!!!

thanks to all who replied

Reply #4

hypersoniq — Fri, 24 Feb 2006 00:08:26 GMT

it requires a conditional formula, built around a nested IF statement...

say column A, Cell 1 had the number 9

then say cell 1 of column B had your first +1

the formula would be

=IF(((A1+1)<10),(A1+1),((A1+1)-10))

format is

=IF(condition, do if true, do if false)

so, the test, or condition, will see if A1+1 is less than 10

if TRUE, just add 1 (7 becomes 8, 0 becomes 1 etc)

if FALSE, add 1, then subtract 10 (9+1=10, then -10=0)

change the 1 to whatever step you... [ More ]

Reply #3

lottaloot — Fri, 24 Feb 2006 00:04:24 GMT

=RIGHT(AD2,1)*1

Meant to say LDR

If you meant the other side, just change right to left

Reply #2

lottaloot — Thu, 23 Feb 2006 23:42:33 GMT

Are you saying that you want the total sum of the combo (i.e, 897=24) and then to have a remainder of 4 be returned as the root sum

Reply #1

cps10 — Thu, 23 Feb 2006 21:36:14 GMT

That is a tough one...I would be interested to see that as well

Please help with simple Excel formula

calabs — Thu, 23 Feb 2006 21:29:54 GMT

Can someone please help me with a simple Excel formula?

I'm looking to create a simple spreadsheet which incorporates additives, ie, the 123 method, or the 023, or one up/one down. When I make the speadsheet, what I need to do is to drop the tens digit so it does not carry it over as per basic lottery math.

Thanks in advance for any help