Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Having trouble combining 4 cells with formulas into one cell formu
I've got formula in 4 cells (fourth cell is the end result I need), that I've
tried to combine into one long formula in one end result cell, but I can't get it to work. I'm still learning formula aughh. If someone can combine them for me that would be awsome because I'm starting to go cross eyed! Cell A1 - is customer take a ticket number being served i.e. =J50 Cell B1 - is customer take a ticket number being issued i.e. =A10 Cell C1 =100*(CODE(UPPER(LEFT(A1,1)))-65)+VALUE(RIGHT(A1,2)) "FORMULA TO CONVERT CELL A1 TO A NUMBER VALUE" i.e. =950 Cell D1 =100*(CODE(UPPER(LEFT(B1,1)))-65)+VALUE(RIGHT(B1,2)) "FORMULA TO CONVERT CELL B1 TO A NUMBER VALUE" i.e. =10 Cell F1 =MOD(D1-C1, G1) "FORMULA TO SHOW THE NUMBER OF CUSTOMER NUMBERS WAITING TO BE SERVED - BASED ON NUMBER OF TICKETS OUT AND HOW HIGH IN THE ALPHABET THE ROLL OF NUMBERS GO BEFORE STARTING AGAIN AT #A00." i.e. =60 Cell G1 =ABS(((CODE(UPPER(LEFT(H1,1)))-65) - (CODE(UPPER(LEFT(I1,1)))-65) ))* 100 + 100 "FORMULA TO COUNT HOW MANY TICKETS ARE ISSUED BEFORE STARTING TICKET #A00 IS ISSUED AGAIN." i.e. =1000 Cell H - is the starting letter of the alphabet the number rolls start with. i.e. =A Cell I - is the ending letter of the alphabet the number rolls end with. i.e. =J I'm trying to eliminate Cells C1, D1, G1 by combining their formula into the formula in Cell F1. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Having trouble combining 4 cells with formulas into one cell formu
=MOD((100*(CODE(UPPER(LEFT(B1,1)))-65)+VALUE(RIGHT(B1,2)))-
(100*(CODE(UPPER(LEFT(A1,1)))-65)+VALUE(RIGHT(A1,2))), ABS(((CODE(UPPER(LEFT(H1,1)))-65) - (CODE(UPPER(LEFT(I1,1)))-65)))*100+100) -- HTH RP (remove nothere from the email address if mailing direct) "jimtmcdaniels" wrote in message ... I've got formula in 4 cells (fourth cell is the end result I need), that I've tried to combine into one long formula in one end result cell, but I can't get it to work. I'm still learning formula aughh. If someone can combine them for me that would be awsome because I'm starting to go cross eyed! Cell A1 - is customer take a ticket number being served i.e. =J50 Cell B1 - is customer take a ticket number being issued i.e. =A10 Cell C1 =100*(CODE(UPPER(LEFT(A1,1)))-65)+VALUE(RIGHT(A1,2)) "FORMULA TO CONVERT CELL A1 TO A NUMBER VALUE" i.e. =950 Cell D1 =100*(CODE(UPPER(LEFT(B1,1)))-65)+VALUE(RIGHT(B1,2)) "FORMULA TO CONVERT CELL B1 TO A NUMBER VALUE" i.e. =10 Cell F1 =MOD(D1-C1, G1) "FORMULA TO SHOW THE NUMBER OF CUSTOMER NUMBERS WAITING TO BE SERVED - BASED ON NUMBER OF TICKETS OUT AND HOW HIGH IN THE ALPHABET THE ROLL OF NUMBERS GO BEFORE STARTING AGAIN AT #A00." i.e. =60 Cell G1 =ABS(((CODE(UPPER(LEFT(H1,1)))-65) - (CODE(UPPER(LEFT(I1,1)))-65) ))* 100 + 100 "FORMULA TO COUNT HOW MANY TICKETS ARE ISSUED BEFORE STARTING TICKET #A00 IS ISSUED AGAIN." i.e. =1000 Cell H - is the starting letter of the alphabet the number rolls start with. i.e. =A Cell I - is the ending letter of the alphabet the number rolls end with. i.e. =J I'm trying to eliminate Cells C1, D1, G1 by combining their formula into the formula in Cell F1. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting Cells Equal only if Destination Cell Does Not Have a Formu | Excel Discussion (Misc queries) | |||
Extracting info from one col. and combining it with a simple formu | Excel Discussion (Misc queries) | |||
Displaying 'IF' Function result (text) over cells containing formu | Excel Worksheet Functions | |||
Combining multiple formulas in one cell | Excel Worksheet Functions | |||
linking a cell with a specific letter value to a cell with a formu | Excel Worksheet Functions |