[EDITED]
Is a a command "button" that will run a massive formula (Instead of having it inside the cell) possible ?
I could use that to process a compeltely different way that I could figure out myself .... Any help is appricaited...
Thanks !
Example -> button
=if(a1 = 250, z1 = 1)
=if(a2 = 251, z1 = 2)
=if(a3 = 252, z1 = 3)
=if(b1 = 257, y1 = 1)
=if(b2 = 258, y2 = 2)
=if(b2 = 259, y2 = 3)
etc...
[EDIT]
-->original post
Hey all, its been a while,,,
I can't figure out how to "minipulate multiple numbers as a single unit "...
(I dont know how else to explain it, ....)
-----------------------------
[EDIT]
[UPDATE, trying to figure out IF THEN ELSE - see the below reply post]
[EDIT]
Example, MONDAY tab is my spreadsheet to auto-total my totals. However,
I must hand write a second sheet because I must list out the actual codes,
such as "209, 401, 403" ---
As an example,
The code 401 simply means "one *FIRST* box" BUT, the code 402 could mean
either (1) (2) or (3) boxes *additional* boxes. If I install *3* boxes,
I would use codes 401 & 403. THIS TRANSLATES TO A *401* & *(Two)* 402 CODES* on my totals sheet ... What I need to do, is after I type the
"2" "402"'s in the MONDAY tab, have the code "403" automatically
generated/typed out in the "codes" box on the PRINT1 worksheet.
I know its confusing but does that make sense ?
402-404 (Up to three)
411-413 (Up to three)
453-456 (Up to four)
250-255 (Up to six)
257-262 (Up to six)
214-216 (Up to three)
And if that wasn't confusing enough,
358,363 (up to two, BUT, the second 358 code is actually a 363 code (NOT 359) - A code of 363 MEANS (2) two 258's ... seriously)
-------------------------------------------
I can handle the details if I could be directed on "HOW TO" even go about doing this.
THANKS !!!
Bookmarks