Pages:
1
2 |
defstarsteve
Posting Freak
Posts: 3505
Registered: 11-19-2003
Member Is Offline
|
|
anyone good at excel or similar spreadsheet programs
I can write basic functions all day long
but I need some written that I just can't seem to get straight
basically I need a function that will take 2 inputted variables that will lead to a data search and return the appropriate answer
i.e. number of shirts vs. number of colors = price/profit
u2u or email def-star@def-star.com if you can help
or mock me if not
|
|
BDx13
|
|
so you need to take the value of two cells, then run those numbers through a function that includes some other, external variables, is that right?
that's a little too rich for my excel blood.
you could try elance. i've used it on a few occasions recently. if you want, write it up as clear as possible and i'll post it to my account.
probably find someone to do it for $20.
If I fail math, there goes my chance at a good job and a happy life full of hard work.
|
|
defstarsteve
Posting Freak
Posts: 3505
Registered: 11-19-2003
Member Is Offline
|
|
kind of, it's only the 2 variables
I have all of my base prices and profits set into a worksheet, all of which are dependent on number of colors in the print and the number of shirts to
be printed...
so I want to be able to enter those two variables and be given the price/profit on the job...
save me from doing it manually everytime
from that I can calculate the profit per hour and such...
I have a nice quote program that I bought a few years ago but it's not capable of pulling these number correctly...
I apprecaite the offer
i was thinking somebody might be geek enough so we could work it out... without hiring an outside nerd, but it looks like I might have to go that
route.
|
|
Mark Lind
Posting Freak
Posts: 1900
Registered: 9-18-2004
Member Is Offline
|
|
That sounds like what you'd use Access for. If anyone here knows it will be Handsome Chris. But I think you're using the wrong application for the
goal.
As related, does anyone know how to transfer a number into a time? For example, Maria was on the phone for 192 seconds. If you divide that by 60 then
you get 3.20 minutes. But I want it to read 3:12 which is the actual result. Anyone know how to reformat that cell?
|
|
defstarsteve
Posting Freak
Posts: 3505
Registered: 11-19-2003
Member Is Offline
|
|
I don't want to use an actual databse though I just wanted to do a little spreadsheet I could carry around...
make quckie quote on if need be
there should be a regular funtion to do that conversion
let me check and see what I can find
|
|
random
Posting Freak
Posts: 2293
Registered: 7-30-2006
Member Is Offline
|
|
Steve,
I think I get what you're asking for. I'll send a crappy example to the email you gave to see if I'm understanding correctly, and we can take it from
there.
|
|
Murk
Posting Freak
Posts: 1243
Registered: 5-15-2005
Member Is Offline
|
|
Steve, it sounds like a detailed "if, then" formula, lemmy think about it for a bit...
Quote: | Originally posted by Mark Lind
As related, does anyone know how to transfer a number into a time? For example, Maria was on the phone for 192 seconds. If you divide that by 60 then
you get 3.20 minutes. But I want it to read 3:12 which is the actual result. Anyone know how to reformat that cell? |
right click on the cell, select [format cells], under category, select [time], and it will give you a list of options.
|
|
defstarsteve
Posting Freak
Posts: 3505
Registered: 11-19-2003
Member Is Offline
|
|
that's what I thought as well
use an if then with nested vlookup
|
|
defstarsteve
Posting Freak
Posts: 3505
Registered: 11-19-2003
Member Is Offline
|
|
mark
this is it
=TEXT(A1/(24*60*60), "mm:ss")
enter 192 into a1
got 3:12
|
|
Mark Lind
Posting Freak
Posts: 1900
Registered: 9-18-2004
Member Is Offline
|
|
Holy shit. That worked. Amazing! Thanks.
I don't really understand how it worked. I've never used the =TEXT before. What does that mean?
And by using the , "mm:ss" I know its telling it to convert to minutes and seconds. But what other options could you potentially use in the field?
Anyone know how to do formulas when a negative number is invlved?
|
|
Mark Lind
Posting Freak
Posts: 1900
Registered: 9-18-2004
Member Is Offline
|
|
Quote: | Originally posted by Murk
Steve, it sounds like a detailed "if, then" formula, lemmy think about it for a bit... |
Calling Handsome Chris.... these formulas are his bread and butter.
|
|
random
Posting Freak
Posts: 2293
Registered: 7-30-2006
Member Is Offline
|
|
Steve - email sent.
Mark - What are you looking to do with negative numbers? Excel will definitely do it, but you can change the cell formatting to use a negative sign,
parentheses (used in accounting most of the time), etc.
|
|
defstarsteve
Posting Freak
Posts: 3505
Registered: 11-19-2003
Member Is Offline
|
|
reading now
Mark google is my best friend, I can find damn near anything, and I have no idea how the text function works
but I'm glad that worked for you
I was reaching dead ends last night that is why I brought my problems here
damn live journal
|
|
Mark Lind
Posting Freak
Posts: 1900
Registered: 9-18-2004
Member Is Offline
|
|
Quote: | Originally posted by random
Steve - email sent.
Mark - What are you looking to do with negative numbers? Excel will definitely do it, but you can change the cell formatting to use a negative sign,
parentheses (used in accounting most of the time), etc. |
Basically I'm using a formula to determine productivity variances. But then I need to apply Steve's formula to that column as well. And it is freaking
out over the negative signs. It's giving me a #VALUE!
Jesus.... if I had known all you guys were Excel slaves too then I probably would have just come here with my woes before and saved myself some
heartburn.
|
|
defstarsteve
Posting Freak
Posts: 3505
Registered: 11-19-2003
Member Is Offline
|
|
we are all nerds here....
|
|
random
Posting Freak
Posts: 2293
Registered: 7-30-2006
Member Is Offline
|
|
I hate seeing #VALUE!
Did you type a formula in one cell, it worked, and then you tried to click & drag the formula into other cells (and you get #VALUE! in those cells)?
I kept having it happen for some other reason at one point when trying to use some built-in formulas in Excel. It would happen if I hit "Enter". I
needed to hit some combination of other keys... I think it was "Ctrl + Shift + Enter" at the same time.
|
|
BDx13
|
|
this thread got more action than i expected and quicker, too.
i was thinking databse for steve's problem as well, but it should be doable in excel.
for mark's, i was also thinking to simply change the cell format to a time format.
well done, everyone!
If I fail math, there goes my chance at a good job and a happy life full of hard work.
|
|
defstarsteve
Posting Freak
Posts: 3505
Registered: 11-19-2003
Member Is Offline
|
|
worst case I will go the database route
but If I can build the excel I can use it on my phone...
quotes made easy on the spot...
screw dragging a laptop around
|
|
Murk
Posting Freak
Posts: 1243
Registered: 5-15-2005
Member Is Offline
|
|
Quote: | Originally posted by Mark Lind
Basically I'm using a formula to determine productivity variances. But then I need to apply Steve's formula to that column as well. And it is freaking
out over the negative signs. It's giving me a #VALUE! |
try this:
Quote: | Originally posted by Murk
right click on the cell, select [format cells], under category, select [time], and it will give you a list of options. |
|
|
chris
Member
Posts: 170
Registered: 12-30-2005
Member Is Offline
Mood: sixer - busted knuckles and heart breaks
|
|
Quote: | Originally posted by defstarsteve
worst case I will go the database route
but If I can build the excel I can use it on my phone...
quotes made easy on the spot...
screw dragging a laptop around |
Shouldn't be too hard, can you post a dumbed down version of the excel sheet? I'm sure you don't want your info online but if you gave the columns
and some example fake data I'm sure we could whip something up for you quickly.
|
|
defstarsteve
Posting Freak
Posts: 3505
Registered: 11-19-2003
Member Is Offline
|
|
give me an email address and I'll send out what I have to anyone who wants to help
|
|
XHonusWagnerX
Moderator
Posts: 12509
Registered: 7-14-2005
Location: pawtucket
Member Is Offline
Mood: hadDCore
|
|
this thread could have been in japanese and I wouldnt have understood it any less than I do right now.
Quote: | Originally posted by REV.PAULIE
HONUS-as much as i can't stand a great deal of what you really like (for my own reasons that i would never hold,nor impose,against you),YOU FUCKING
RULE!
YOU,HONUS,IS WHAT MAKES THE "EDGE" COOL.
YOUR FRIEND,
PAULIE |
check out my post contributions at www.VinylNoize.com
|
|
DAK
Posting Freak
Posts: 3507
Registered: 5-13-2004
Member Is Offline
|
|
|
|
chris
Member
Posts: 170
Registered: 12-30-2005
Member Is Offline
Mood: sixer - busted knuckles and heart breaks
|
|
scarsboston at y ahoo dot com
|
|
defstarsteve
Posting Freak
Posts: 3505
Registered: 11-19-2003
Member Is Offline
|
|
email sent
|
|
Pages:
1
2 |