Hi, I'm in a tight spot with a formula I have to come up with. I need to create it using something called "chaldean numerology" or something; the basis is that the resulting digits have to sum 8 in total.
The criteria that I need to use is:
LOW PRICES / UNDER 1000
0 to 999.99 prices need to end x.88
where they don’t change the first integer XX8.xx until the number sums 8
1000 - 1999
all prices need to SUM 8
I need to change the first integer XXX8.xx until the number sums to 8
LAST TWO INTEGERS = 00
+ example, price = 1317.88 BECOMES 1320.00
OVER 2000
all prices need to SUM to 8
I need to change the integers XX00.00 until the number sums to 8
LAST TWO INTEGERS = 00
+ example, price = 2317.88 BECOMES 2320.00 or higher
Here is the breakdown of a price and how the formula would work on a perfect world:
Product Price = 63.97
+ below 1000?
+ yes
+ change .97 to .88
then sum all numbers
+ 63.88
+ = 6 + 3 + 8 + 8
+ = 9 + 16 = 25
+ is 25 single digit? no
+ reduce it
+ 25 = 2 + 5 = 7
+ is 7 and 8?
+ no
+ then change the price until the sum of the numbers is 8
Product Price = 1183.97
+ above 999.99?
+ yes (so drop .97 and make .00)
+ does 1183 i.e. 1 + 1 + 8 + 3 add to 8?
+ no
+ therefore round up until SUM OF NUMBER (each number added up individually & double numbers reduced) = 8
+ so...... 1 + 1 + 8 + 3 = 13
+ 13 is it a single number?
+ therefore add the double digits together to make SINGLE DIGIT
+ 13 = 1 + 3 = 4
+ is the 4 = 8
+ no
+ then change the number until the SUM of each number is 8
+ which by the way is 1187.00
+ 1 + 1 = 2 + 8 = 10 + 7 = 17 which is 1 + 7 = 8
Product price = 3997.97
+ above 2000?
+ yes
+ therefore, x.97 becomes x.00
+ so new price is $3993.
+ is the last integer = x (i.e. is the price 3990?)
No
+ so we have to process
+ 3993 we round up = 3940
+ does #3940 END with xx0.00?
+ yes
NEXT
+ we have to check that numbers SUM to 8
+ 3940 = 3 + 9 + 4 + 0 = 3 + 9 = 12 + 4 = 16
+ is 16 a single number?
No
+ reduce to single digits then
+ 16 = 1 + 6 = 7
+ is 7 an 8?
I have been unable to come up with the sum to 8 and change digits until the prices sums to 8. I'm at my wits end and nearing a breakdown because I do not comprehend the basis of the numerology system. Hope this makes sense! Thank you in advance and sorry, I am not an expert on formulas
The criteria that I need to use is:
LOW PRICES / UNDER 1000
0 to 999.99 prices need to end x.88
where they don’t change the first integer XX8.xx until the number sums 8
1000 - 1999
all prices need to SUM 8
I need to change the first integer XXX8.xx until the number sums to 8
LAST TWO INTEGERS = 00
+ example, price = 1317.88 BECOMES 1320.00
OVER 2000
all prices need to SUM to 8
I need to change the integers XX00.00 until the number sums to 8
LAST TWO INTEGERS = 00
+ example, price = 2317.88 BECOMES 2320.00 or higher
Here is the breakdown of a price and how the formula would work on a perfect world:
Product Price = 63.97
+ below 1000?
+ yes
+ change .97 to .88
then sum all numbers
+ 63.88
+ = 6 + 3 + 8 + 8
+ = 9 + 16 = 25
+ is 25 single digit? no
+ reduce it
+ 25 = 2 + 5 = 7
+ is 7 and 8?
+ no
+ then change the price until the sum of the numbers is 8
Product Price = 1183.97
+ above 999.99?
+ yes (so drop .97 and make .00)
+ does 1183 i.e. 1 + 1 + 8 + 3 add to 8?
+ no
+ therefore round up until SUM OF NUMBER (each number added up individually & double numbers reduced) = 8
+ so...... 1 + 1 + 8 + 3 = 13
+ 13 is it a single number?
+ therefore add the double digits together to make SINGLE DIGIT
+ 13 = 1 + 3 = 4
+ is the 4 = 8
+ no
+ then change the number until the SUM of each number is 8
+ which by the way is 1187.00
+ 1 + 1 = 2 + 8 = 10 + 7 = 17 which is 1 + 7 = 8
Product price = 3997.97
+ above 2000?
+ yes
+ therefore, x.97 becomes x.00
+ so new price is $3993.
+ is the last integer = x (i.e. is the price 3990?)
No
+ so we have to process
+ 3993 we round up = 3940
+ does #3940 END with xx0.00?
+ yes
NEXT
+ we have to check that numbers SUM to 8
+ 3940 = 3 + 9 + 4 + 0 = 3 + 9 = 12 + 4 = 16
+ is 16 a single number?
No
+ reduce to single digits then
+ 16 = 1 + 6 = 7
+ is 7 an 8?
I have been unable to come up with the sum to 8 and change digits until the prices sums to 8. I'm at my wits end and nearing a breakdown because I do not comprehend the basis of the numerology system. Hope this makes sense! Thank you in advance and sorry, I am not an expert on formulas
